Oracle sqlserver MySQL三种数据库查询分页语句

MySQL查询分页语句

select * from table where id limit (pagenow-1)*pagesize,pagesize;

sqlserver查询分页语句

select top pagenum * from table where id not in(select top (pagesize-1)*pagesize from table)


Oracle查询分页语句

select * from (select rownum,r from table r<=pagenum*pagesize)where r>=(pagesize-1)*pagenum