Record

Tue, 06 Oct 2015 15:30:02 GMT

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?

Re: Record

sunny_talwar — Tue, 06 Oct 2015 20:07:54 GMT

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;