如果您知道要跳过多少条记录,则可以执行以下操作:
SELECT *
FROM myTable x
WHERE x.ID NOT IN (SELECT Top 10 id FROM myTable ORDER BY ....)
ORDER BY ...
然后,您可以排除不需要的记录。
如果您随后知道要返回的记录总数,则可以执行以下操作:
SELECT Top 50 *
FROM myTable x
WHERE x.ID NOT IN (SELECT Top 10 id FROM myTable ORDER BY ....)
ORDER BY ...