http://blog.youkuaiyun.com/oldwolf1987/archive/2009/04/06/4051396.aspx
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
oracle分页查询
最新推荐文章于 2025-08-07 21:09:17 发布
http://blog.youkuaiyun.com/oldwolf1987/archive/2009/04/06/4051396.aspx
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
31万+
