在SQL Server中，数据库中有两张表student(stuid,stuname,stuage)，score(stuid,subject,marks)。下面哪些查询可查找出参加过考试的学生姓名？（）【选三项】A、select stuname from student where stuid in(select stuid from score)B、select stuname from student,score where student.stuid=score.stuidC、select stuname from student left outer join score on student.stuid=score.stuidD、select stuname from student where exists (select * from score where student.stuid=score.stuid)-易过题库-题库最全的搜题网站

在SQL Server中，数据库中有两张表student(stuid,stuname,stuage)，score(stuid,subject,marks)。下面哪些查询可查找出参加过考试的学生姓名？（）【选三项】

Aselect stuname from student where stuid in(select stuid from score)

Bselect stuname from student,score where student.stuid=score.stuid

Cselect stuname from student left outer join score on student.stuid=score.stuid

Dselect stuname from student where exists (select * from score where student.stuid=score.stuid)

试题详情