查找学生姓名及其所选修课程的课程号和成绩,正确的SQL语句是A.SELECT sname FROM student,SELECT

Question

查找学生姓名及其所选修课程的课程号和成绩,正确的SQL语句是

A．SELECT sname FROM student,SELECT cno,grade FROM sc WHERE student.sno=sc.sno

B．SELECT sname,cno,grade FROM student,course WHERE student.sno=course.cno

C．SELECT sname,cname,grade FROM student,course,sc WHERE student.sno=sc.sno and sc.cno=course,cno

D．SELECT sname,cno,grade FROM student,sc WHERE student.sno=sc.sno

Answer 1

正确答案：D
解析：题意中要求查找学生姓名、课程号和成绩,这三个属性可以查找两个关系表student和sc,通过条件student.so=sc.so进行连接。