gpt4 book ai didi

sql - 如何在 SQL 查询 where 子句中指定多个值?

转载 作者:行者123 更新时间:2023-12-02 07:42:40 25 4
gpt4 key购买 nike

我当前的查询是:

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

最佳答案

我想你想要:

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

关于sql - 如何在 SQL 查询 where 子句中指定多个值?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/9377577/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com