题解 | 获得积分最多的人(一)
获得积分最多的人(一)
https://www.nowcoder.com/practice/1bfe3870034e4efeb4b4aa6711316c3b
select b.name,a.grade_num from
(SELECT
user_id,
SUM(grade_num) AS grade_num,
max(sum(grade_num)) OVER() AS max_grade_num
FROM grade_info
GROUP BY user_id) a join user b on a.user_id=b.id
where a.grade_num=a.max_grade_num
查看16道真题和解析