SELECT player, SUM(score)
FROM
(SELECT player_1 AS player, score
 FROM t
 UNION ALL
 SELECT player_2 as player, score
 FROM t) sub
GROUP BY player

你必须将玩家1的结果和玩家2的结果结合起来，这样你就只有一个玩家和分数的结果了。当然，分数会在这个视图中列出两次，每个玩家一次。在我的查询中，结果被称为sub。根据sub，你可以按玩家分组并计算他们的分数。

你可以这样做 union all 以及 group by :

select player, sum(score)
from ((select player1 as player, score from game_info
      ) union all
      (select player2 as player, score from game_info
      )
     ) p
group by player
order by sum(score) desc;