Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have ttable which consist of 100members .But my requirement is to print only last 40members
Any help will be appreciarted
Thanks
How do you define last 40 members? Is it based on date?
Can you provide sample input and expected output
i wouild like to sort it out with the help of rowno .
Thanks
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;