注意：此页面搜索的是所有试题
题目内容
（国家开放大学数据库应用技术）
对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 StudentWHERE 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 StudentWHERE Sno FROM SC AND Grade>75
参考答案