单项选择题

查询姓张、姓王、姓刘老师的信息的方法是 A.
SELECT *
FROM Teacher
WHERE Teachername like '张%' and Teachername like '王%' and Teachername like '刘%' B.
SELECT *
FROM Teacher
WHERE Teachername like '张%' or Teachername like '王%' and Teachername like '刘%' C.
SELECT *
FROM Teacher
WHERE Teachername like '张%' or Teachername like '王%' or Teachername like '刘%' D.
SELECT *
FROM Teacher
WHERE Teachername like '张%' and Teachername like '王%' or Teachername like '刘%'

微信扫码免费搜题