Record

[#1]

Hi Experts,

I have  one table  fields  like  number ,name,location each field having 25 records.Here my question is

how to get first 5 and last 5 records?

[sunny_talwar]

During load you should be able specify

For First 5

TableName:

FIRST 5

LOAD YourFields....

FROM....

For Last 5

TableName:

LOAD RowNo() as RowNum,

          YourFields

FROM....

FinalTable:

NoConcatenate

FIRST 5

LOAD *

Resident TableName

Order By RowNum desc;

Drop Table TableName;