ROWNUM 是一个伪列，他会根据返回的记录生成一个序列化的数字，在oracle中我们可以用它来实现分页查询
SELECT * FROM ( SELECT T.*, ROWNUM RN FROM ( sql) T WHERE ROWNUM <= start + size) WHERE RN >start
例子：
SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM <= 40 ) WHERE RN >= 21
转载请注明原文地址: https://www.6miu.com/read-44072.html
