Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i have one table i want last 100 records in table
How about this?
Table:
First 10
Load * From Table Order By FieldName Desc;
OR
Table:
Load * from Table;
NoConcatenate
Final:
First 10
LOAD * Resident Table Order By FieldName desc;
DROP Table Table;
try using peek function in your load script..
In your table add one field for counting the rows Ex:- Rowno() as Rid and then use this field to load last 100 data from the table.
NoConcatenate
LOAD * Resident SourceTable Where Rid > 100;
DROP Table SourceTable;
Table :
Load
RecNo() as Sno,
RowNo() as Rownum
resident Transact where Sno<=100 order by Sno desc ; //Transact is already loaded table .