MSSQL行转列、列转行

行转列

SELECT *

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

 

 

 

列转行

 

 

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