MYSQL GROUP BY MAX得分

本文介绍了MYSQL GROUP BY MAX得分的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个名为scores的表，其中包含列

I have a table called scores which contains columns

如何选择哪个id_team是每场得分最高的得分手

How do I select which id_team is top scorer per game

我正在尝试这样做，但这不是正确的结果

i m trying with this, but that's not correct result

SELECT MAX( score ) , id_team FROM scores GROUP BY `id_game` LIMIT 0 , 30

推荐答案

您可以使用自我加入来找出得分最高的游戏a的正确团队ID

You can use a self join to find out the right team id for game a which has max score

SELECT s.* FROM scores s JOIN ( SELECT MAX(score) score, id_game FROM scores GROUP BY id_game ) ss USING(score ,id_game ) LIMIT 0 , 30