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