SQL> select * from aa;IDD ONE TWO
---------- ---------- ----------
a 2.00
a 3.00
b 4.00
a 1.00
b 5.00 SQL> select * from (select * from aa order by one desc) where rownum=1;IDD ONE TWO
---------- ---------- ----------
b 5.00 SQL>
---------- ---------- ----------
a 2.00
a 3.00
b 4.00
a 1.00
b 5.00 SQL> select * from (select * from aa order by one desc) where rownum=1;IDD ONE TWO
---------- ---------- ----------
b 5.00 SQL>
这条语句应该是一条记录都取不到的吧
SQL> select * from(
2 select aa.*, row_number() over(order by one desc) rk from aa)
3 where rk=1;IDD ONE TWO RK
---------- ---------- ---------- ----------
b 5.00 1SQL>