SELECT a.ID, a.Name
FROM (SELECT TOP 10010 *
FROM table1) a LEFT OUTER JOIN
(SELECT TOP 10000 *
FROM table1) b ON a.ID = b.ID
WHERE (b.ID IS NULL)
ORDER BY a.ID
用下面这样的语句可以得到10到20条记录,但是不能加order by语句。
SELECT a.ID, a.Name
FROM (SELECT TOP 20 *
FROM table1) a LEFT OUTER JOIN
(SELECT TOP 10 *
FROM table1) b ON a.ID = b.ID
WHERE (b.ID IS NULL)