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
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