注意：此页面搜索的是所有试题
题目内容
（国家开放大学数据库应用技术模拟试题）
对Student(Sno,Sname)和SC(Sno,Cno,Grade)表，查询考试成绩小于60分的学生的学号和姓名，正确的语句是（ ）。
A. SELECT Sno, Sname FROM SC WHERE Grade<60
B. SELECT Sno, Sname FROM Student WHERE Grade<60
C. SELECT Sno, Sname FROM Student WHERE Sno IN( SELECT Sno FROM SC WHERE Grade<60 )
D. SELECT Sno, Sname FROM StudentWHERE Sno FROM SC AND Grade<60
A. SELECT Sno, Sname FROM SC WHERE Grade<60
B. SELECT Sno, Sname FROM Student WHERE Grade<60
C. SELECT Sno, Sname FROM Student WHERE Sno IN( SELECT Sno FROM SC WHERE Grade<60 )
D. SELECT Sno, Sname FROM StudentWHERE Sno FROM SC AND Grade<60
参考答案