注意:此页面搜索的是所有试题
题目内容
(国家开放大学数据库应用技术模拟试题)
查询考试成绩大学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
参考答案