我要从表a中读数据，条件：字段b满足=@b，并且字段c满足=@c或者=@d,应该怎么写
------解决方案--------------------------------------------------------
(b=@b AND c=@c ) OR (b=@b AND c=@d)?
------解决方案--------------------------------------------------------
select * from table where b=@b and (c=@c or c=@d)
------解决方案--------------------------------------------------------
b=@b and (c=@c or c=@d)
------解决方案--------------------------------------------------------
select *from a where b=@b and c=@c or c=@d
------解决方案--------------------------------------------------------
不加括号也可以，AND 比 OR优先级高
------解决方案--------------------------------------------------------
select *from a where b=@b and (c=@c or c=@d)
不加括号不行