DB2,Oracle,SQL server,Mysql分页查询语句

db2:
select t1.* from (
	select t.*,rownumber() over(order by t.id ASC)) as rn from t_students t
) as t1 where t1.rn between (pageNum-1)*pageSize and pageNum*pageSize


Oracle:
select * from (
	select t.*,t.rownum from t_student t 
) where rownum>pageSize*(pageNum-1) and rownum<=pageSize*pageNum;

sql server:
select top pageSize t.* from t_students t
where t.id not in (
	select top (pageNum-1)*pageSize t1.id from t_students t1 order by t1.id
)order by t.id;

mysql:
select * from t_students t limt (pageNum-1)*pageSize,pageSize;