不过这种方式对于大批量数据会很慢
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];