2021-08-18

oracle数据库分页自用记录一下

利用开窗函数统计出个数
row_number ( ) over ( ORDER BY ID ) rn，
count( 0 ) over ( ) cnt,
再利用between…and…来分
WHERE rn BETWEEN (页码 -1) * 条数+1 AND 页码 * 条数
WITH sj as (
SELECT
row_number ( ) over (ORDER BY ID DESC ) rn
,count( 0 ) over ( ) cnt
FROM
ryxx
)
SELECT
*
FROM
sj
WHERE rn BETWEEN (2 -1) * 5+1 AND 2*5

---

WHERE rn BETWEEN (页码 -1) * 条数+1 AND 页码 * 条数