不同数据库的分页语句

1.MySql

String sql = "select * from students order by id limit "

+pageSize*(pageNumber - 1)

+","

+pageSize;

2.Sql Server

String sql = "select top"

+pageSize

+"* from students where id not in"

+"(select top "

+pageSize*(pageNumber - 1)

+"id from students order by id)"

+"order by id";

3.Oracle

String sql = "select * from "

+(select *,rownum rid from (select * from students order by postime desc ) where rid <="

+pageSize * pageNumber 

+") as  t"

+"where t>"

+pageSize*(pageNumber - 1);

例如：

取出Sql表中31到40条的记录。

①Mysql ：

select * from t order by id limit 30,10;

②Sql Server

select top 10 * from t where id not in (select top 30 id from t order by id) order by id;

③Oracle

select * from (select rownum r,* from t where r<=40) where r>30;