本文探讨了SQL查询中使用ROWNUM实现分页及筛选特定条件数据的优化技巧，通过实例展示了如何高效地从数据库中获取所需信息。
SELECT * FROM test
WHERE ROWID IN (
SELECT rid FROM (
SELECT rid, ROWNUM AS rn FROM (
SELECT ROWID rid FROM test
WHERE a1 LIKE '%%'
ORDER BY id
) t1 WHERE ROWNUM<=10000
) t2 WHERE rn>=9990
) ORDER BY id
WHERE ROWID IN (
SELECT rid FROM (
SELECT rid, ROWNUM AS rn FROM (
SELECT ROWID rid FROM test
WHERE a1 LIKE '%%'
ORDER BY id
) t1 WHERE ROWNUM<=10000
) t2 WHERE rn>=9990
) ORDER BY id
扫一扫
1974
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
