oracle很经典的分页查询
SELECT rn 序号, empno 员工编号, ename 姓名, job 职位, sal 工资
FROM ( SELECT rownum rn , empno, ename, job, sal
FROM (SELECT empno, ename, job, sal FROM emp ORDER BY sal DESC) t1
) t2
WHERE rn >=4 AND rn <=6;
oracle很经典的分页查询
SELECT rn 序号, empno 员工编号, ename 姓名, job 职位, sal 工资
FROM ( SELECT rownum rn , empno, ename, job, sal
FROM (SELECT empno, ename, job, sal FROM emp ORDER BY sal DESC) t1
) t2
WHERE rn >=4 AND rn <=6;