分数表scores设计如下:
courseID(课程编号)
studentID(学生编号)
score(分数)
另有一个学生信息表student,包含studentID,sname(学生姓名)。
已知并非所有学生都参加了考试,现在查询所有及格学生的学生姓名,下面正确的是?
select sname from student where studentID in (select studentID from score where score>60)
select sname from student where studentID = (select studentID from score where score>60)
select sname from student where studentID not in (select studentID from score where score<=60)
select sname from student where exists (select studentID from score where score>60)
select sname from student where studentID in (select studentID from score where score>60)这个错在哪里了啊,为什么不选它啊。我套你猴子~~~~~