SELECT * FROM
(
SELECT temp.*, ROWNUM RN
FROM (SELECT * FROM 表名) temp
WHERE ROWNUM <=end (page*pagesize)
)
WHERE RN >start (page-1*pagesize)
转载于:https://www.cnblogs.com/furenjian/p/11388425.html
SELECT * FROM
(
SELECT temp.*, ROWNUM RN
FROM (SELECT * FROM 表名) temp
WHERE ROWNUM <=end (page*pagesize)
)
WHERE RN >start (page-1*pagesize)
转载于:https://www.cnblogs.com/furenjian/p/11388425.html