题解 | #获得积分最多的人(三)#
获得积分最多的人(三)
http://www.nowcoder.com/practice/d2b7e2a305a7499fb310dc82a43820e8
SELECT id,name,grade_sum
FROM (SELECT user_id,grade_sum,dense_rank() over(ORDER by grade_sum DESC) r
FROM (SELECT user_id,sum(if(type='add',grade_num,grade_num * (-1))) grade_sum
FROM grade_info
GROUP BY user_id) gf) gr
JOIN user u ON u.id=gr.user_id
WHERE r=1
