题解 | #获得积分最多的人(三)#
获得积分最多的人(三)
https://www.nowcoder.com/practice/d2b7e2a305a7499fb310dc82a43820e8
SELECT u.id, u.NAME, c.m AS gn FROM user AS u LEFT JOIN( select user_id,m,dense_rank() over (order by m desc) as t_rank from ( select user_id,sum(ng) as m from ( select user_id, case when type='add' then grade_num else -(grade_num) end as ng from grade_info) a group by user_id) b )c on u.id=c.user_id where c.t_rank=1 ;
查看17道真题和解析
深信服公司福利 409人发布
投递快手等公司10个岗位