如下表student中,如何筛选type为包含数学或语文的记录。?IDtypescore?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 (数学? 语文)