Oracle取查询结果数据的第一条记录SQL

Oracle取查询结果数据的第一条记录SQL:

select * from (select * from <table> order by <key>) where rownum=1;
select * from (select * from <table> order by <key> desc) where rownum=1;
原文地址:https://www.cnblogs.com/xusweeter/p/5837423.html