题解 | 获得积分最多的人(二)
获得积分最多的人(二)
https://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
select b.id,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
order by b.id
查看6道真题和解析