一个SQL问题

Question

select * from tab where score = ( select max(score) from tab );

Answer 1

SQL> select * from stu;        ID NAME       SEX               OLD
---------- ---------- ---------- ----------
         1 无悔       男                 77
         2 流浪汉     男                 76
         3 彭敏       女                100
         4 kk         女                100
         5 ww         男                500
         6 qq         男                 30
         7 ii         男                 30
         8 uu         男                 30
         9 aa         男                 20
        10 rr         男                 20
        11 qqww       男                 30        ID NAME       SEX               OLD
---------- ---------- ---------- ----------
        12 rtrt       男                 20已选择12行。SQL> select * from stu where old in (select max(old) from stu);        ID NAME       SEX               OLD
---------- ---------- ---------- ----------
         5 ww         男                500

Answer 2

select * from (select * from tablename order by score desc) where rownum<=1