数据库分页

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;

作者“javaeedevelop”