How to get 2 rows that match 1 ID?

Question

PHP

There is a table:
id, name, gameID, scores
gameID - unique for every two players.
Is it possible to get the first 100 pairs of players (with the highest scores) with a single request?
Is it better to do multiple requests?

Answer 1

SELECT t1.*, t2.*, (t1.scores+t2.scores) as score_sum FROM talbe t1
JOIN table t2 ON t1.gameID = t2.gameID AND t2.id <> t1.id
ORDER BY score_sum DESC
LIMIT 100
as something so...