例如有一张Student表ID、Name字段查询ID 10到30之间的Name 且ID不是连续的
如下代码
SELECT
Distinct Name
FROM Student
WHERE [ ID ] NOT IN ( SELECT Top 10 [ ID ] FROM Studnet) AND [ ID ] in( SELECT Top 30 [ ID ] Student)
WHERE [ ID ] NOT IN ( SELECT Top 10 [ ID ] FROM Studnet) AND [ ID ] in( SELECT Top 30 [ ID ] Student)