虽然网上例子很多,但是试过多种办法都无效,原代码出处:
https://blog.csdn.net/qyshibb/article/details/73332075
这个例子简单有效
select p.* from (select * from tablename t order by t.maxnum desc) p where rownum = 1
虽然网上例子很多,但是试过多种办法都无效,原代码出处:
https://blog.csdn.net/qyshibb/article/details/73332075
这个例子简单有效
select p.* from (select * from tablename t order by t.maxnum desc) p where rownum = 1