创建临时表

对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

select t1.id, t1.name group by t1.id 你这是怎么过的，group by id，然后对name连聚合函数都不用就select?

select u.id, u.name,b.tot from (select a.user_id,a.tot,dense_rank()over(order by a.tot desc) rk from (select user_id, sum(grade_num) tot from grade_info group by user_id) a )as b join user as u on u.id=b.user_id where b.rk=1 order by u.id

创建临时表属于玩赖吧。。

对name字段没有聚合导致出现错误

需要改进一下， group by id，name