作者：乔山办公网日期：
返回目录：excel表格制作
oracle分页的核心：
SELECT
*
FROM (SELECT
T1.*,
ROWNUM rn
FROM (SELECT
*
FROM testTable
ORDER BY id DESC) T1
WHERE ROWNUM <= 20)
WHERE rn > 0;
大量数据时oracle分页语句的优化（通过rownum和rowid来进行分页），如下：
SELECT
t1.*
FROM testTable t1, (SELECT
rid
FROM (SELECT
ROWNUM rn,
t.rid
FROM (SELECT
ROWID rid
FROM testTable
WHERE 1 = 1) t
WHERE ROWNUM <= 20)
WHERE rn > 0) t2
WHERE 1 = 1 AND t1.ROWID = t2.rid;
本文标签：excel分页(32)