SELECT *
FROM (SELECT a.*, Rownum r FROM (
/* 你的查询语句 */
) a WHERE Rownum <= 100) b
WHERE r > 10
ORACLE分页查询语句
最新推荐文章于 2024-07-17 08:42:49 发布
SELECT *
FROM (SELECT a.*, Rownum r FROM (
/* 你的查询语句 */
) a WHERE Rownum <= 100) b
WHERE r > 10