Oracle 分页
SELECT C.*, ROWNUM CROWNUM
FROM (SELECT B.*, ROWNUM BROWNUM
FROM (SELECT A.*, ROWNUM AROWNUM FROM T_BOOK A) B
WHERE ROWNUM <= 10) C
WHERE BROWNUM > 5;
Oracle 分页
SELECT C.*, ROWNUM CROWNUM
FROM (SELECT B.*, ROWNUM BROWNUM
FROM (SELECT A.*, ROWNUM AROWNUM FROM T_BOOK A) B
WHERE ROWNUM <= 10) C
WHERE BROWNUM > 5;