题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
http://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
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)
