我相信有一个动态的SQL答案会更好地满足您的需求，但下面是您如何使用MAX硬编码多个行号来将行转换为列：

WITH CTE AS 
(SELECT *, 
  ROW_NUMBER() OVER (PARTITION BY match_id ORDER BY match_id) AS RN
  FROM player_matches)
SELECT 
  match_id,
  MAX(CASE WHEN rn = 1 THEN player END) AS player_1,
  MAX(CASE WHEN rn = 2 THEN player END) AS player_2,
  MAX(CASE WHEN rn = 3 THEN player END) AS player_3,
  MAX(CASE WHEN rn = 4 THEN player END) AS player_4,
  MAX(CASE WHEN rn = 5 THEN player END) AS player_5,
  MAX(CASE WHEN rn = 6 THEN player END) AS player_6,
  MAX(CASE WHEN rn = 7 THEN player END) AS player_7,
  MAX(CASE WHEN rn = 8 THEN player END) AS player_8,
  MAX(CASE WHEN rn = 9 THEN player END) AS player_9,  
  MAX(CASE WHEN rn = 10 THEN player END) AS player_10
FROM CTE a
GROUP BY match_id

结果：

| match_id | player_1 | player_2 |
|----------|----------|----------|
| 1        | messi    | lebron   |
| 2        | kobe     | federer  |
| 3        | serena   | woods    |

演示here .