mysql - mySQL中如何显示最高分

Question

我想在几轮之后显示得分最高的玩家。这是表格:

PlayerID   Round   number of score
   1         1           4
   2         1           5
   3         1           8
   1         2           3
   2         2           10
   3         2           7

预期输出

PlayerID         number of score
   2                     15
   3                     15

我试过这段代码，但这里出错了。如何显示输出？

SELECT playerID , MAX(SUM(numberOfGoals)) FROM Game;

Answer 1

试试这个:

SELECT playerID,  SUM(numberOfGoals) AS numberOfGoals
FROM Game
GROUP BY playerID
HAVING SUM(numberOfGoals) IN (SELECT MAX(goals) FROM (SELECT SUM(numberOfGoals) goals 
FROM Game GROUP BY playerID) t)