多項選擇題

如下表student中,如何篩選type為包含數(shù)學或語文的記錄?()

A.select*from student where type=“數(shù)學” and type=“語文”
B.select*from student where type=“數(shù)學” or type=“語文”
C.select*from student where type in(“數(shù)學”,“語文”)
D.select*from student where type in(“數(shù)學”、“語文”)

微信掃碼免費搜題