题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
https://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
SELECT u.id, u.NAME, b.m FROM user u LEFT JOIN ( SELECT user_id, m, rank() over ( ORDER BY m desc) AS t_rank FROM ( SELECT user_id, sum( grade_num ) AS m FROM grade_info group by user_id) a ) b ON u.id = b.user_id WHERE b.t_rank = 1 order by id;
