sql - 如何在 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)