三种数据库的分页(mysql,sqlserver,oracle)

1、mysql
select * from 表名 where 条件 limit 起始页,每页记录数
示例

select * from admins a ,t_role r where a.zw=r.roleId and a.zw!=1 limit 0,10

2、sqlserver

select top 每页记录数 * from  表名 where 字段名 not in (select top ((第几页-1)*每页记录数) 字段名 from  表名  order by 字段名  desc )  order by 字段名 desc

示例
select top 10 * from  admins a, t_role r where rec_id not in (select top 0 rec_id from  admins  order by rec_id  desc ) order by rec_id desc

3、oracle
示例:这里是第2页，每页大小为3
select * from
(
select a.*,rownum rn from
(
      select * from sims_student
) a where rownum<=6--当前页*每页大小
) b where rn>3--(当前页-1)*每页大小