1 A. 2 3 --SELECT TOP 15 * FROM Customer 4 -- WHERE CustomerID NOT IN(SELECT TOP (15*(2-1)) CustomerID FROM Customer 5 -- ORDER BY CustomerID) 6 -- ORDER BY CustomerID 7 8 9 10 B. 11 --select top 15 * from Customer where CustomerID not in 12 -- (select top (15 *(10-1)) 13 -- CustomerID from Customer 14 -- order by CustomerID) 15 -- order by CustomerID 16 17 收藏于 2011-02-09