單項選擇題

已知表student,字段如下:

取出course1,course2,course3三門成績均超過60分的記錄,可以使用如下查詢語句()

A.select*from student where course1+course2+course3>60
B.select*from student where course1 and course2 and course3>60
C.select*from student where max(course1,courser2,course3)>60
D.select*from student where course1>60 and course2>60 and course3>60

微信掃碼免費搜題