题解 | #获得积分最多的人(二)#
https://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
select a.id,a.name,a.grade_num from
(select id,name,sum(grade_num) as grade_num
,rank() over (order by sum(grade_num) desc) as num
from user join grade_info
on user.id=grade_info.user_id
group by id,name) a
where a.num=1
order by id
(select id,name,sum(grade_num) as grade_num
,rank() over (order by sum(grade_num) desc) as num
from user join grade_info
on user.id=grade_info.user_id
group by id,name) a
where a.num=1
order by id
腾讯成长空间 523人发布
投递美的集团等公司10个岗位 >