Reg:Is "Last" is possible?

[#1]

Hi All,

Any one opf you please let me know is it possible to fetch "Last N" rows from the table.Since "First" key word using to fetch "First N" rows from the table.Let me know the same.

Thanks & Regards

Jai

[sparur]

Hello, Jai.

I think it can do it only by 2 steps:

1) tmp:

LOAD *,

rowno() as RowNo

FROM...

2) ResultTable:

First N

LOAD *

RESIDENT tmp

ORDER BY RowNo DESC;

DROP TABLE tmp;