Question

SQL语句,一共有5个变量，只要满足其中任意三个变量或以上的SQL语句怎么写？

Answer 1

select *
from table
where 1=1
and (
case when condition1(@arg1) is true then 1 else 0 end
+ case when condition2(@arg2) is true then 1 else 0 end
+ case when condition3(@arg3) is true then 1 else 0 end
+ case when condition4(@arg4) is true then 1 else 0 end
+ case when condition5(@arg5) is true then 1 else 0 end
) >= 3

Answer 2

最简单的就是用使用and和or来完成