查询学生的学号,姓名,系,专业,所选课程的课程号、课程名和成绩

2024-01-13

查询学生的学号,姓名,系,专业,所选课程的课程号、课程名和成绩

A.select * from student,course,sc where sudent.sid=sc.sid and course.cid=sc.sid

B.select sid,sname,depart,zhuanye,cid,cname,grade from student,course,sc where student.sid=sc.sid and course.cid=sc.sid

C.select student.sid,sname,depart,zhuanye,cid,cname,gradefrom student,course,sc where student.sid=sc.sid and course.cid=sc.sid

D.select student.sid,sname,depart,zhuanye,course.cid,cname,gradefrom student,course,sc where student.sid=sc.sid and course.cid=sc.sid



参考答案:

select student.sid,sname,depart,zhuanye,course.cid,cname,gradefrom student,course,sc where student.sid=sc.sid and course.cid=sc.sid

相关推荐