题解 | #获得积分最多的人(二)#

select u.id,u.name,sum(g.grade_num) as 'grade_sum' from user u join grade_info g on u.id=g.user_id group by u.id,u.name having grade_sum =(select sum(grade_num) rnk from grade_info g1 group by user_id order by rnk DESC limit 1)