不过这种方式对于大批量数据会很慢
select top 每页条数 * from 表名 where [ID] not in
(select top 每页条数*(页数-1) [ID] from 表名 order by [ID])
order by [ID];
不过这种方式对于大批量数据会很慢
select top 每页条数 * from 表名 where [ID] not in
(select top 每页条数*(页数-1) [ID] from 表名 order by [ID])
order by [ID];