如何同时使用带有 NOT IN 或 equals 的 SQL WHERE CASE？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14844006/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-01 13:40:28 来源:igfitidea点击:
how use SQL WHERE CASE with NOT IN or equals at the same time?
提问by Warren
Hi all (my first post on the Stack!),
大家好（我在 Stack 上的第一篇文章！），
This works:
这有效：
where
Tran_date between @FromDate and @ToDate
and Range = @Range
and Store_ID =
case when @Range = 'RangeName' then
1234
else
Store_ID
end
but how can I achieve this?:
但我怎样才能做到这一点？：
where
Tran_date between @FromDate and @ToDate
and Range = @Range
and Store_ID
case when @Range = 'RangeName' then
not in (1234, 5678)
else
Store_ID
end
采纳答案by GilM
I think you want:
我想你想要：
AND NOT (@Range = 'RangeName' AND Store_ID IN (1234,5678))
回答by Kenneth Fisher
where
Tran_date between @FromDate and @ToDate
and Range = @Range
and Store_ID
case when @Range = 'RangeName' AND Store_Id in (1234, 5678)
9999 -- Assumes 9999 is a non possible value.
-- If it is possible then pick one that isn't.
else
Store_ID
end
回答by bobs
How about this:
这个怎么样：
where Tran_date between @FromDate and @ToDate
and Range = @Range
and (@Range = 'RangeName' and Store_ID not in (1234, 5678)
or @Range <> 'RangeName' and Store_ID = Store_ID)
