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