题解 | #牛客每个人最近的登录日期(三)#
获得积分最多的人(三)
http://www.nowcoder.com/practice/d2b7e2a305a7499fb310dc82a43820e8
select id,name,grade_sum from (select u.id,u.name,sum(if(type='add',grade_num,-grade_num)) grade_sum, dense_rank() over(order by sum(if(type='add',grade_num,-grade_num)) desc) as rank1 from user u,grade_info g where u.id=g.user_id group by u.name,u.id) a where rank1 =1 order by id
虾皮信息公司福利 770人发布
