Oracle 查询出来的数据取第一条;
select * from (select * from <table> order by <key>) where rownum=1;
select * from (select * from <table> order by <key> desc) where rownum=1;
Oracle 查询出来的数据取第一条;
select * from (select * from <table> order by <key>) where rownum=1;
select * from (select * from <table> order by <key> desc) where rownum=1;
转载于:https://my.oschina.net/dylan2hdf/blog/847063