先按用户id进行分组计算sum,然后排序后去第一行,再跟另一个表进行连接
select user.name,t.grade_sum from
(select user_id,sum(grade_num) as grade_sum from grade_info group by user_id order by grade_sum desc limit 1) t
join user
on t.user_id=user.id
先按用户id进行分组计算sum,然后排序后去第一行,再跟另一个表进行连接
select user.name,t.grade_sum from
(select user_id,sum(grade_num) as grade_sum from grade_info group by user_id order by grade_sum desc limit 1) t
join user
on t.user_id=user.id