SQL> select * from tjh_test where rowid=(select rowid from (select last_value(rowid) over(order by r
ownum) rowid from tjh_test) where rownum=1);
select * from tjh_test where rowid=(select rowid from (select last_value(rowid) over(order by rownum
*
ERROR 发生在第 1 行:
ORA-00923: 未找到预期 FROM 关键字
rowid最大不一定最后记录
select * from table_name where rowid=(select rowid from (select last_value(rowid) over(order by rownum) rowid from table_name) where rownum=1);
试一下下面的语句,应该可以:
select * from table_name where rowid=(select rowid from (select rowid from table_name order by rowid desc) where rownum=1)
我刚学Oracle,有什么问题请大家提出来,相互提高。