last 100 records

[rajareddyjkl]

hi 

i have  one table i  want  last  100 records in  table

[Anil_Babu_Samineni]

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;

[poppypearce]

try using peek function in your load script..

[its_anandrjs]

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;

[navin]

Table :
Load
RecNo() as Sno,
RowNo() as Rownum
 resident  Transact where Sno<=100 order by Sno desc ;      //Transact is already loaded table .