Pair up row in Sql : I have a Players table with 3 columns id, name, wins(number of win matches). To make a Swiss pairing, I sort this table order by wins. How can I return a table with 4 columns id1, name1, id2, name2 such that each row of new table is the pair of rows in Players table. I can do it in python language, but I want to know that there is any query in SQL which could implement this task?
For example
Player table
Id   Name   Wins
1     A      3
2     B      1
3     C      4
4     D      0
I want to return
Id   Name   Id   Name
3     C      1    A
2     A      4    D    

Thanks