查询Oracle表中最后一行数据(行顺序与DATE字段无关): select * from (select * from TABLE order by rownum) where rownum < 2; 查询Oracle表中最后一行数据(行顺序与DATE字段有关): select * from (select t.* from TABLE t order by t.DATE) where rownum < 2;
第2个回答 2012-03-27
select * from (select * from scott.emp order by rownum desc) where rownum <=1