Question

SQL中select语句，where后面条件有2个A，B，C。现在要求选出满足条件A，以及满足B或C二者之一的记录。

即这条记录满足条件A和B，或者满足条件A和C。SQL语句怎样写？

Answer 1

select * from table where A='' and (B='' or C='')
不知道对不对

Answer 2

select 字段 from 表名 where A and (b or c)

Answer 3

select * from tb where A and (B or C)

Answer 4

where a=a and (b=b or c=c)

Answer 5

where A and (B or C)