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

原文地址:https://www.cnblogs.com/xusweeter/p/5837423.html

select * from (select * from <table> order by <key>) where rownum=1;
select * from (select * from <table> order by <key> desc) where rownum=1;
posted @ 2021-06-04 14:04  eyesfree  阅读(770)  评论(0编辑  收藏  举报