1按“0001”号课程成绩由高到低顺序显示所有学生学号、姓名、成绩(二表连接); SELECT student.student_id, student.student_name, student_course.score FROM student, student_course WHERE student.student_id = student_course.student_id AND student_course.course_id = '0001' ORDER BY student_course.score ...
表2:grade 表3:student_info select distinct s.学号,s.姓名,g.课程编号,g.分数 from grade g inner join student_info s on s.学号=g.学号 where g.分数=(select MAX(分数) from grade where 学号=g.学号)
最后一行也是这个位置也是同样问题 GRADE.课程编号=CURRICULUM .课程编号 这个位置也是 select e.学号,e.姓名,f.课程编号,f.分数 from STUDENT e,(select c.学号 学号,c.分数 分数,d.课程编号 课程编号 from GRADE d,(select b.学号,MAX(a.分数)分数 from GRADE a,STUDENT b where a.学号=b....
group by st_id,st_name,c_no group by s.st_id,sc.st_name,sc.c_no这句