SELECT * FROM
(
SELECT 表名.*, ROWNUM TT FROM 表名 WHERE ROWNUM <= N AND
)
WHERE TT >=M;
ORACLE查询第m条到第n条数据
最新推荐文章于 2021-12-14 14:21:54 发布
SELECT * FROM
(
SELECT 表名.*, ROWNUM TT FROM 表名 WHERE ROWNUM <= N AND
)
WHERE TT >=M;