MSSQL行转列、列转行

行转列

SELECT *
FROM student
PIVOT (
    SUM(score) FOR subject IN (语文, 数学, 英语)
) AS PivotedData;

列转行

SELECT *
FROM student1
UNPIVOT (
    score FOR subject IN ("语文","数学","英语")
)AS PivotedData;