mysql 查询给出单条查询SQL，需求得：所有学生历次考试的最高分

Question

给出单条查询SQL，需求得：所有学生历次考试的最高分。
所有学生历次考试的最高分

Answer 1

select b.student_id,a.name, b.max_score,c.score_time from (SELECT student_id,max(score_num) as max_score FROM table_b  group by student_id) as b
left join table_b as c
left join table_a as a
on b.student_id=c.student_id and b.max_score =c.score_num and a.student_id=b.student_id

试试