设有关系模式:SC(sno,cno,grade),各属性含义依次是学号、课程号、分数。要查询分数低于60分的学生学号,正确的SQL语句是______。 A: SEI,ECT sno FROM SC WH ERE grade BETWEEN O AND 60 B: SELECT sno FROM SC WHERE grade<60 C: SELECT sno FROM SC HAVlNG grade BETWEEN O AND 60 D: SELECT sno FROM SC HAVING grade<60
设有关系模式:SC(sno,cno,grade),各属性含义依次是学号、课程号、分数。要查询分数低于60分的学生学号,正确的SQL语句是______。 A: SEI,ECT sno FROM SC WH ERE grade BETWEEN O AND 60 B: SELECT sno FROM SC WHERE grade<60 C: SELECT sno FROM SC HAVlNG grade BETWEEN O AND 60 D: SELECT sno FROM SC HAVING grade<60
1