查询表里某个字段10-30之间的数据且ID不是连续的

例如有一张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)