使用SQL Server查询将多个select语句合并为一个语句
使用SQL Server查询将多个select语句合并为一个语句
提问于 2019-06-25 04:06:15
我想使用以下逻辑查询我的SQL Server DB中的一个表：
declare @crntusrdept nvarchar(128)
set @crntusrdept = 'A'
if @crntusrdept includes ('A', 'B', 'C') then (select * from comps where dept in ('A', 'B', 'C'))
if @crntusrdept includes ('D','E') then (select * from comps where dept in ('D','E'))
if @crntusrdept includes ('F', 'G') then (select * from comps where dept in ('F', 'G'))
if @crntusrdept includes ('H') then (select * from comps where dept in ('H'))回答 1
Stack Overflow用户
发布于 2019-06-25 04:10:45
您可以执行以下操作：
select *
from comps
where @crntusrdept in ('A', 'B', 'C') and dept in ('A', 'B', 'C')
or @crntusrdept in ('D', 'E') and dept in ('D', 'E')
or @crntusrdept in ('F', 'G') and dept in ('F', 'G')
or @crntusrdept in ('H') and dept in ('H')页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/56743281
复制相关文章
相似问题