while statement

Finance and Operations/AX Technical Forum
1

Lets say i would like to select 3rd record onwards from a customize table called tmp_KMN which id number for the the 3rd record is 12334, can i use below while statement?
while SELECT * FROM tmp_KMN
order by id
where tmp_KMN.Id >= ‘12334’

2

Hi misha,

Yes, You can use the above statement.

3

Thank you Chaitanya [:D]

4

Hi, while SELECT * FROM tmp_KMN order by id where tmp_KMN.Id >= ‘12334’ This is correct statement you have written . You can you this.