oracle中分页查询

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

select * 
    from
        (select rownum rowno, t.* from tab t where rownum <= page*size) tab_alias
    where 
        tab_alias.rowno > (page-1)*size;

 有order by语句的分页(group by 类似)

select *
    from
        (select rownum rowno, m.*
            from
                (select * from tab order by id) m
            where rownum <= page*size) n
    where n.rowno > （page-1)*size;
                

MySql中分页查询sql格式

select * from table limit m,n;

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