在這裡我用Northwind裡的Orders表實驗
第一種：SELECT TOP 10 *
FROM Products
WHERE (ProductID NOT IN
(SELECT TOP 30 ProductID
FROM Products
ORDER BY ProductID)) //一定要加上ORDER BY ProductID
第二種：SELECT TOP 10 *
FROM (SELECT TOP 40 *
FROM Products
ORDER BY ProductID DESC) DERIVEDTBL
ORDER BY ProductID //這種好像結果不太對，有待進一步驗證
第三種：SELECT *
FROM Products
WHERE (ProductID IN
(SELECT TOP 40 ProductID
FROM Products
ORDER BY ProductID)) AND (ProductID NOT IN
(SELECT TOP 30 ProductID
FROM Products
ORDER BY ProductID))
