Oracle - 分页查询

1 SELECT * FROM (
2 
3     SELECT a.*, ROWNUM rn FROM (
4     
5         SELECT * FROM table_name
6         
7     ) a WHERE ROWNUM <= [当前页 * 每个页面显示的条数]
8     
9 ) WHERE rn > [(当前页-1) * 每个页面显示的条数]

转载于:https://www.cnblogs.com/mpci/p/11205006.html