試題詳解

40）查找学生姓名及其所选修课程的课程号和成绩，正确的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