oracle两种分页查询
第一种:
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM table_name) A WHERE ROWNUM <= 10) WHERE RN >= 1;
第二种:
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A) WHERE RN BETWEEN 0 AND 10;
建议用第一种。
第一种:
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM table_name) A WHERE ROWNUM <= 10) WHERE RN >= 1;
第二种:
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A) WHERE RN BETWEEN 0 AND 10;
建议用第一种。