sqlServer not in 分页

select top 10 * from GoodsTab WHERE GoodsID NOT IN (
SELECT TOP (10*(2-1) GoodsID FROM dbo.GoodsTab WHERE GoodsTypeID=2 ORDER BY GoodsID DESC ) AND GoodsTypeID=2 ORDER BY GoodsID DESC
原文地址:https://www.cnblogs.com/lbx6935/p/12305254.html