Question

如何查oracle表中最后一行数据

有DATE字段，其他字段都是无序排列，麻烦各位大大给与帮助!

Answer 1

查询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;

Answer 2

select * from (select * from scott.emp order by rownum desc) where rownum <=1