sql - 如何在没有聚合的情况下部分转置 SQL 表

Question

我需要你们关于部分转换这个 MS SQL 表的专家建议:

| Term | Listening | Reading | Speaking | Writing |
| AC1  | 12        | 15      | 18       | 13      |
| AC2  | 17        | 14      | 9        | 12      |

进入这个:

| Term | Comp      | Score |
| AC1  | Listening | 12    |
| AC1  | Reading   | 15    |
| AC1  | Speaking  | 18    |
| AC1  | Writing   | 13    |
| AC2  | Listening | 17    |
| AC2  | Reading   | 14    |
| AC2  | Speaking  | 9     |
| AC2  | Writing   | 12    |

如果您能提供建议，不胜感激。提前致谢。

Answer 1

您要的是 UNPIVOT :

SELECT Term, Comp, Score
FROM mytable
UNPIVOT
   (Score FOR Comp IN 
      ([Listening], [Reading], [Speaking], [Writing])
)AS unpvt;