select * from table_name a where a.rownum=(select max(b.rownum) from table_name b)
select count(*) from m_purd; COUNT(*) 160083 目前歷時: 00:00:00.60select * from (select * from m_purd order by rownum desc) where rownum<2; 目前歷時: 00:00:00.71 select * from m_purd where rowid>=(select max(rowid) from m_purd ); 目前歷時: 00:00:00.21因為我多次測試﹐所以SGA中已存在﹐故速度快了許多.
select top 1 * from tbname order by desc;在SQLSERVER中能用,在oracle为什么不管用呢? select * from (select * from table order by rownum) where rownum=1
order by desc
COUNT(*)
160083 目前歷時: 00:00:00.60select * from (select * from m_purd order by rownum desc) where rownum<2;
目前歷時: 00:00:00.71
select * from m_purd where rowid>=(select max(rowid) from m_purd );
目前歷時: 00:00:00.21因為我多次測試﹐所以SGA中已存在﹐故速度快了許多.
select * from (select * from table order by rownum) where rownum=1