CodeAugust 13, 2007 3:38 pm
Select Last N Records from Table
The following clever SQL statement selects the last 10 records from a table. Works for Oracle. Did not check for other databases.
select * from (select rownum as RecNum, column1,column2 ,…,columnn from my_table)
where RecNum > ( select (max(rownum)-10) from my_table);
From zhijie_stone
