Oracle与Mysql的分页

mysql limit 开始数 ，个数

select * from table_name limit 1000,10;

oracle 三层嵌套

SELECT * FROM

(

SELECT A.*, ROWNUM RN

FROM (SELECT * FROM TABLE_NAME) A

WHERE ROWNUM <= 40

)

WHERE RN >= 21