Oracle 查询出来的数据取第一条

select * from (select * from <table> order by <key>) where rownum=1;

select * from (select * from <table> order by <key> desc) where rownum=1;
posted @ 2017-07-10 17:15  离。  阅读(312)  评论(0编辑  收藏  举报