-- Oracle分页(效率好)
SELECT *
FROM (SELECT A.*
, ROWNUM RN
FROM (SELECT *
FROM EMP
) A
WHERE ROWNUM <= 200
)
WHERE RN >= 100;
-- Oracle分页(效率不好)
SELECT *
FROM (SELECT A.*
, ROWNUM RN
FROM (SELECT *
FROM EMP
) A
)
WHERE RN BETWEEN 100 AND 200