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;

查询一结果：


查询二结果：

Oracle 分页

原文：https://www.cnblogs.com/szl6/p/9519888.html