题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
https://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
select a.id, a.name, b.total as grade_num
from (
select t.user_id, dense_rank() over(order by t.total desc) as ranks, t.total
from (
select user_id, sum(grade_num) as total
from grade_info
group by user_id
) t
) b
left join user a
on a.id = b.user_id
where b.ranks = 1
