i would like to print last 40 records

[Anonymous]

Hi All,

i have ttable which consist of 100members .But my requirement is to print only last 40members

Any help will be appreciarted

Thanks

[anbu1984]

How do you define last 40 members? Is it based on date?

Can you provide sample input and expected output

[Anonymous]

i wouild like to sort it out with the help of rowno .

Thanks

[anbu1984]

Temp:

Load *,Rowno() As RowNo From Table;

NoConcatenate

Final:

Load * Where RwNo <= 40;

Load *,Recno() As RwNo Resident Temp Order by RowNo desc;

Drop Table Temp;