1.分页查询
SELECT *
FROM (SELECT ROW_.*, ROWNUM RN
FROM (
SELECT * FROM table1 ) ROW_
WHERE ROWNUM <= 40)
WHERE RN > 20
1.分页查询
SELECT *
FROM (SELECT ROW_.*, ROWNUM RN
FROM (
SELECT * FROM table1 ) ROW_
WHERE ROWNUM <= 40)
WHERE RN > 20