1、mysql
select * from 表名 where 条件 limit 起始页,每页记录数
示例
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)*每页大小
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)*每页大小