mssql 分页

select top @pageSize id from tablename
where id not in (
select top @offset id from tablename
)

 

select top 10 id　from　zd_customer_new
where id not in (
select top 3 id from zd_customer_new
)

 

select *　from　zd_customer_new

 

 

 

 

https://blog.csdn.net/nocomment_84/article/details/55047196