如果不介意在系统中使用HINT的话,可以将分页的查询语句改写为:
SELECT
*
FROM
(SELECT
a
.*,
ROWNUM
rn
FROM
(SELECT
*
FROM
table_name
)
a
WHERE
ROWNUM
<=
40
)
WHERE
rn
>=
21