对name字段没有聚合方式，group by u.id,u.name即可，稍加修改即可通过 WITH t AS ( SELECT u.id, u.name, SUM(gi.grade_num) AS grade_sum FROM user u JOIN grade_info gi ON u.id = gi.user_id GROUP BY u.id,u.name ) SELECT id, name, grade_sum FROM t WHERE grade_sum = (SELECT MAX(grade_sum) FROM t) ORDER BY t.id