如何在SQL查询where子句中指定多个值？

Question

我当前的查询是：

Select Distinct 
    SomeDay.SomeDayID, SomeDay.FolderName, SomeDay.FolderColor 
from 
    SomeDay, SomeDayEvent 
where 
    SomeDay.SomeDayID != 4,3,2,1; 

Answer 1

我想你想：

Select Distinct 
    SomeDay.SomeDayID, SomeDay.FolderName, SomeDay.FolderColor 
from 
    SomeDay, SomeDayEvent 
where 
    SomeDay.SomeDayID not in (4,3,2,1) 

Answer 2

这应该是这样的

Select Distinct 
    SomeDay.SomeDayID, SomeDay.FolderName, SomeDay.FolderColor 
from 
    SomeDay, SomeDayEvent 
where 
    SomeDay.SomeDayID != 4 
and 
    SomeDay.SomeDayID != 3 
and 
    SomeDay.SomeDayID != 2 
and 
    SomeDay.SomeDayID != 1; 

Answer 3

这只是根据您的问题。

Select Distinct 
SomeDay.SomeDayID, SomeDay.FolderName, SomeDay.FolderColor 
from 
SomeDay, SomeDayEvent 
where 
SomeDay.SomeDayID>4;