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;
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;