题解 | 获得积分最多的人(一)
获得积分最多的人(一)
https://www.nowcoder.com/practice/1bfe3870034e4efeb4b4aa6711316c3b
select u.name,sum(g.grade_num)over(partition by g.user_id) su from grade_info g join user u on u.id = g.user_id order by su desc limit 1 如sql所示
获得积分最多的人(一)
https://www.nowcoder.com/practice/1bfe3870034e4efeb4b4aa6711316c3b
select u.name,sum(g.grade_num)over(partition by g.user_id) su from grade_info g join user u on u.id = g.user_id order by su desc limit 1 如sql所示
相关推荐
帮你内推|腾讯云智研发 校招