T-SQL Two Dimension Pivot Table
![圖片](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcMiTzD3Y7gbPt2hntC2wvzEemmQ1b7L7Lc4tUbb4j4CCla7AC6slOdrnyrrbZA9x3XcJlhsAior5Lq-6wjvcy8BgYk1auS7l863SaGRmPambOHdIK-Uj4Gah2VhvHbStTUUaQwNZHCxPR/s16000/image.png)
將原始資料 select BRAND='ASUS', QTY=1, AMT=200 union all select BRAND='BENQ', QTY=1, AMT=200 union all select BRAND='ASUS', QTY=1, AMT=200 union all select BRAND='BENQ', QTY=1, AMT=200 union all select BRAND='MSI', QTY=1, AMT=200 依各品牌匯總數量、金額,做出以下的統計表 解決方法 1 - Group By 加條件式 select ASUS_QTY = SUM(IIF(Src.BRAND='ASUS', Src.QTY, 0)) , ASUS_AMT = SUM(IIF(Src.BRAND='ASUS', Src.AMT, 0)) , BENQ_QTY = SUM(IIF(Src.BRAND='BENQ', Src.QTY, 0)) , BENQ_AMT = SUM(IIF(Src.BRAND='BENQ', Src.AMT, 0)) , MSI_QTY = SUM(IIF(Src.BRAND='MSI', Src.QTY, 0)) , MSI_AMT = SUM(IIF(Src.BRAND='MSI', Src.AMT, 0)) from( select BRAND='ASUS', QTY=1, AMT=200 union all select BRAND='BENQ', QTY=1, AMT=200 union all select BRAND='ASUS', QTY=1, AMT=200 union all select BRAND='BENQ', QTY=1, AMT=200 union all select BRAND='MSI', QTY=1, AMT=200 ) Src 解決方法 2 - Pivot Table 做多維度 Pivot Table