题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
http://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
select id,name,gs from(select id,name,gs,dense_rank()over(order by a.gs desc)dr from (select distinct id,name,sum(grade_num)over(partition by user_id order by user_id)gs from grade_info gi join user u on gi.user_id=u.id)a)b where b.dr=1 order by id
