可以的阿:
SQL> select * from (select * from t11 order by keshi) where rownum<3;KESHI FENL JINE
----- ---- ----
de a 10
de a 11
SQL> select * from (select * from t11 order by keshi) where rownum<3;KESHI FENL JINE
----- ---- ----
de a 10
de a 11
如获取每个部门薪水前三名的员工或每个班成绩前三名的学生。
Select * from
(select depno,ename,sal,row_number() over (partition by depno
order by sal desc) rn
from emp)
where rn<=3
where rn < N
>8I 才可以?