select name,sum(grade_num) grade_sum from user u join grade_info g on u.id=g.user_id group by name order by grade_sum desc limit 1
思路:用一个排序和limit就好了,不懂为什么评论区都要用表连接。
select name,sum(grade_num) grade_sum from user u join grade_info g on u.id=g.user_id group by name order by grade_sum desc limit 1
思路:用一个排序和limit就好了,不懂为什么评论区都要用表连接。