oracle中分页查询教程，oracle分页教程

oracle中分页查询教程，oracle分页教程

SELECT *

FROM ( SELECT ROWNUM AS rowno, t.*

FROM table t WHERE ROWNUM <= page*size) table_aliasWHERE table_alias.rowno > (page-1)*size;

有order by语句的分页:SELECT *

FROM ( SELECT ROWNUM AS rowno,r.*

FROM( SELECT * FROM table t

ORDER BY t.element asc

) r

where ROWNUM <= page*size

) table_alias

WHERE table_alias.rowno > (page-1)*size;

上限条件必须放在子查询，而下限条件必须放在外层查询 (rownum总是从1开始的，第一条不满足去掉的话，第二条的rownum 又成了1)。

顺便提一下 :MySql中分页查询sql格式是：select * from table limit m,n;

其中m是每页起始页码，n是每页显示的条数，m =( pageNum - 1) *n