Oracle 分页
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
-----------------------------------------------------------------------
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
)
WHERE RN BETWEEN 21 AND 40
select e.*,rownum from emp e order by sal;
select e.*,rownum from (select * from emp order by sal) e;
查询一结果:
![](https://images2018.cnblogs.com/blog/1431380/201808/1431380-20180822192705779-1950016936.png)
查询二结果:
![](https://images2018.cnblogs.com/blog/1431380/201808/1431380-20180822192720381-901707246.png)