分页语句

1.oracle数据库分页

    select * from

        (select 表名 .*,rownum rc from 表名 where rownum<=endrow) a

    where a.rc>=startrow;

2.MySQL数据库分页

    Select * from 表名 limit startrow,pagesize; (Pagesize为每页显示的记录条数)

3.通用模式

    select * from

    (select * from student where sid not in

    (select sid from student where rownum<=(currentPage-1)*pageSize)

    ) where rownum <=pageSize;

.