很经典的两种写法:
方法1.
SELECT rownum 序号, empno 员工编号, ename 姓名, sal 工资
FROM (SELECT empno, ename, sal FROM emp WHERE deptno IN(10,20) ORDER BY sal DESC)
ta
WHERE rownum <= 5 ;
方法2.
SELECT rownum 序号, rn 原始行号, empno 员工编号, ename 姓名, sal 工资
FROM (SELECT rownum rn, empno, ename, sal FROM emp WHERE deptno IN(10,20) ORDER
BY sal DESC) ta
WHERE rownum <= 5 ;