Oracle 分页方法(随手记)

方法1：
SELECT LimitResult.*
FROM
(
 SELECT OrderResult.*, rownum AS r FROM (
 SELECT * FROM t_dd_diaodurizhi ORDER BY riqi 
 ) 
 OrderResult WHERE rownum<=20) LimitResult WHERE LimitResult.r>10
 
 ;
 SELECT LimitResult.*
FROM
(
 SELECT OrderResult.*, rownum AS r FROM (
 SELECT * FROM t_dd_diaodurizhi ORDER BY riqi 
 ) 
 OrderResult WHERE rownum<=10) LimitResult WHERE LimitResult.r>0

方法2：
SELECT LimitResult.*
FROM
(
 SELECT OrderResult.*, rownum AS r FROM (SELECT * FROM t_dd_diaodurizhi ORDER BY riqi DESC )  OrderResult WHERE rownum<=40) LimitResult WHERE LimitResult.r>20

转载于:https://www.cnblogs.com/LDaqiang/articles/1012778.html