子查询统计分数 子查询查最大值 join返回结果 select t1.id,t1.name,t2.num from user t1 join ( select t.user_id,t.num from ( select user_id,sum(grade_num) as num from grade_info group by user_id ) t where t.num = (select max(tmp.num) from (select sum(grade_num) as num from grade_info group by user_id ) tmp) ) t2 on...