Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;