题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
https://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
select t1.user_id, name, sum_g grade_num from ( select user_id, sum(grade_num) sum_g, max(sum(grade_num))over() max_sum_g from grade_info where type = 'add' group by user_id, type ) t1 join user u on t1.user_id = u.id where sum_g = max_sum_g order by user_id;