mysql/DB2/sql server2008的分页方式

MySQL分页查询

select  * from table limit beginIndex，maxRow

select * from table limit 10,20

DB2分页查询

select * from（

select rownumber() over() as rc,a.* from 表名 a

）where rc between startRow and endRow.

sql server分页查询

select top pagesize * from 表名 where 列名 not in(

select top pagesize*(page-1) 列名 from 表名 order by 列名

)order by 列名

通用分页

select * from（

select * fromtable where 列名 not in（

select  列名 from table where rownum <= （currentPage-1）*pageSize

）where rownum <=pageSize

）