如下表student中,如何筛选type为包含数学或语文的记录?() ID type score: A01数学78; A02语文76; A03英语90; A04数学68; A05英语84。
- A、select*from student where type=”数学”and type=”语文”
- B、select*from student where type=”数学”or type=”语文”
- C、select*from student where type in(”数学”,”语文”)
- D、select*from student where type in(”数学”、”语文”)
正确答案:B,C
答案解析:有
微信扫一扫手机做题