SQL - 行列转换

--行转列

--select * from [dbo].[StudentScores]

select * from [dbo].[StudentScores] /*数据源*/ as P

Pivot

(

sum(Score /*行转列后 列的值*/ )

for

Subject in ([Language],[Math],[English],[Biolidge]) /*行转列后 列名*/

) as T

 

--列转行

--select * from ProgrectDetail

select * from

 

(select * from ProgrectDetail) T /*数据源*/

unpivot

(

supplynum for Supplier in (OverseaSupply, NativeSupply, SouthSupply, NorthSupply )

) p