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

admin2013-03-16  34

问题 设有关系模式: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

选项 A、 
B、 
C、 
D、 

答案B

解析
转载请注明原文地址:https://kaotiyun.com/show/mBuZ777K
0

最新回复(0)