数据库表结构:
分页语句:
param1为size,也就是每页显示多少条数据;
param2为current * size,其中size为每页显示多少条数据,
current为当前页,从0开始;
select top param1 group_id as groupId, group_name as groupName, createtime from group_manager where group_id not in(select top param2 group_id from group_manager)
sql解释:
select top param1 * from group_manager where group_id not in(select top param2 group_id from group_manager)
//param2 = size * current current = 0表示第一页
//current = 0,第一页,选择前0条,则where条件的判断失效
//current = 1