SELECT
student.sno,
sname,
cname,
grade
FROM
student,
course,
sc
WHERE
student.sno = sc.sno
AND sc.cno = course.cno
AND course.cno = '1'
10. 查询选修了1号课程的学生及其选修课程的情况,保留学生学号,姓名,课程名,成绩
最新推荐文章于 2023-12-22 15:43:45 发布
SELECT
student.sno,
sname,
cname,
grade
FROM
student,
course,
sc
WHERE
student.sno = sc.sno
AND sc.cno = course.cno
AND course.cno = '1'