SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT ROWNUM phaseid FROM dual CONNECT BY ROWNUM <= 100 ) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
sql oracle分页测试
最新推荐文章于 2024-06-27 10:58:53 发布
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT ROWNUM phaseid FROM dual CONNECT BY ROWNUM <= 100 ) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21