题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
https://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
select distinct gg.user_id as id, u.name, gg.grade as grade_num
from user u
join
(select user_id,
grade,
rank()over(order by grade desc) as r_num
from
(select user_id, sum(grade_num)over(partition by user_id) as grade
from grade_info) g
) gg
on u.id=gg.user_id
where gg.r_num=1
order by gg.user_id
查看6道真题和解析