题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
https://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
select id,name,grade_num from (select *, dense_rank() over(order by grade_num desc) as rn from (select g1.user_id as id, u1.name, sum(grade_num) as grade_num from grade_info g1 join user u1 on g1.user_id = u1.id group by g1.user_id,u1.name order by grade_num desc) tb1) tb2 where rn =1;
投递网易游戏等公司6个岗位 >
