with a as (select id, name, sum(grade_num)over(partition by user_id) as grade_sum from user u join grade_info g on u.id=g.user_id order by grade_sum desc ) select id, name, grade_sum from( select *, dense_rank()over(order by grade_sum desc) rk from a) t1 where rk=1 group by id order by id 大佬为啥这样会报错答案一样
点赞

相关推荐

魔法恐龙:这真得给个机会,面试的时候问问不吃饭78.5h怎么做到的
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务