水货求sql

table

a b c

1 cc dd


10 bb mm


查询出 a>1 b,c 的值 在 cc ， dd ， bb ， mm中的记录
[解决办法]

SELECT *
FROM dbo.tablename
WHERE a > 1
AND (b IN('cc', 'dd', 'bb', 'mm') OR c IN('cc', 'dd', 'bb', 'mm'))

create table #tb(a int,b varchar(10),c varchar(10))
insert into #tb
select 1,'cc','dd'
union all select 10,'bb','mm'
union all select 15,'xx','ww'

select *
from #tb
where a>1 and (b in('cc','dd','bb','mm') or c   in('cc','dd','bb','mm'))

/*
abc
-----------------------------------
10bbmm
*/

select *
from tb
where a>1 and b in('cc','dd','bb','mm') and c in('cc','dd','bb','mm')