题解 | #获得积分最多的人(一)#
获得积分最多的人(一)
http://www.nowcoder.com/practice/1bfe3870034e4efeb4b4aa6711316c3b
select a.name,a.grade_sum from
(select *,
sum(grade_num) over(partition by g.user_id) as grade_sum
from grade_info as g
join user as u
on g.user_id = u.id) as a
order by a.grade_sum desc
limit 1; 
地平线公司福利 418人发布
