用rownumber可以实现这个功能: select * from (SELECT a.deptno,(rownum+1-b.min_sno) sno, a.ename,a.sal FROM(SELECT *FROM emp ORDER BY deptno, sal ) a, (SELECT deptno, MIN(rownum) min_sno FROM( SELECT *
FROM emp
ORDER BY deptno, sal desc) GROUP BY deptno) b WHERE a.deptno=b.deptno ) where sno =e1.sal
) <=3 /*这里的数... |