题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
http://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
- 参考答案
select u.id,u.name,sum(g.grade_num) grade_sum
from user u
join grade_info g
on u.id=g.user_id
group by u.id
having grade_sum = (select sum(grade_num) r
from grade_info g1
group by user_id
order by r desc
limit 1)