数据库分页

sql分页

select top (10) * from dbo.QL_GROUP t where t.groupid not in(select top(20) t.groupid from QL_GROUP t order by groupid);

select  * from dbo.QL_GROUP t  order by groupid

mysql分页

page=1; //页数

pageTotal=2; //每页的总条数

select * from subclass order by createtime  limit  page*pageTotal-pageTotal, pageTotal;