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
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