SQL列传行，行转列的操作讲解

SQL行转列(pivot)与列转行(unpivot):

做数据统计时，行转列,列转行是经常遇到的问题。case when 方式太麻烦且拓展性不强。

可以使用pivot，unpivot实现，且拓展良好

pivot:

    select * 
    from [StudentScores] as  P 
    pivot( 
           Sum(Score /*行转列后 列的值*/) 
           for p.Subject/*需要行转的列*/ in ([语文],[数学],[英语],[生物] /*需要显示的列值*/)
       ) as T

unpivot:

    select p.progrectName,p.Supplier,p.SupplyNum
    from ProgrectTable as T
    unpivot (
         SupplyNum for Supplier in (OverseaSupply ,NativeSupply , SouthSupply ,NorthSupply)
     ) As p