如下表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(”数学”、”语文”)
出自:项目数据分析师