Oracle数据库分页

 1 /**
 2 *查询分页
 3 *page:3
 4 *pageSize:10
 5 */
 6 --分页公式
 7 SELECT *
 8   FROM 表
 9  WHERE ROWID IN
10        (SELECT RID
11           FROM (SELECT ROWNUM RN, RID
12                   FROM (SELECT ROWID RID, 主键字段 from 表)
13                  WHERE ROWNUM <= ((page - 1) * pageSize + pageSize)) --每页显示几条
14          WHERE RN > ((page - 1) * pageSize)) --当前页数
15  ORDER BY 主键字段;
16  --实际操作
17 SELECT *
18   FROM student
19  WHERE ROWID IN
20        (SELECT RID
21           FROM (SELECT ROWNUM RN, RID
22                   FROM (SELECT ROWID RID, xh from student)
23                  WHERE ROWNUM <= ((2 - 1) * 6 + 6)) --每页显示几条
24          WHERE RN > ((2 - 1) * 6)) --当前页数
25  ORDER BY xh;