SELECT * FROM (
SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM < page*rows+1
) WHERE RN > (page-1)*rows
Oracle分页SQL语句
最新推荐文章于 2024-08-19 08:45:16 发布
SELECT * FROM (
SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM < page*rows+1
) WHERE RN > (page-1)*rows