如:每页5行;查询第二页:
SELECT *
FROM (SELECT T1.*, ROWNUM PNUM
FROM (select * from t_user) T1
WHERE ROWNUM <= 10) T2
WHERE PNUM > 5;
个人理解为如下:
SELECT *
FROM (SELECT T1.*,ROWNUM PNUM
FROM (查询得到的所有表数据,如;select * from t_user) T1
WHERE ROWNUM <= 所查询的页数的总行数,如:每页5行,查询第一页为5,查询 第二面为10,查询第三 页为15,查询第四页为20) T2
WHERE PNUM > 所查询页数前一页最后一行是第几行,如:每页5行,查询第一页为0,查询第二页为5,查询第三页为10,查询第四页为15;
SELECT *
FROM (SELECT T1.*, ROWNUM PNUM
FROM (select * from t_user) T1
WHERE ROWNUM <= 10) T2
WHERE PNUM > 5;
FROM (SELECT T1.*, ROWNUM PNUM
FROM (select * from t_user) T1
WHERE ROWNUM <= 10) T2
WHERE PNUM > 5;