题解 | #获得积分最多的人(一)#

用Limite 查询出最大值 想问下大家为什么group by 要加name

    select u.name,sum(g.grade_num) as total
    from user u left outer join grade_info g
        on u.id=g.user_id
    group by g.user_id,u.name
    order by total desc
    limit 0,1