题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
http://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
select u.id,u.name,t.grade_num
from user u
join (select user_id,sum(grade_num) grade_num from grade_info group by user_id) t
on u.id = t.user_id
join (select sum(grade_num) maxg from grade_info group by user_id order by maxg desc limit 1) n
on t.grade_num = n.maxg
order by u.id
腾讯稳定性 120人发布
投递中国银行等公司10个岗位 >
