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”