列欄轉置語法(PIVOT)

SELECT "欄位1"  
      ,"欄位2"  
      ,"欄位3"  
      ,"A","B","C","D" /**轉置後的欄位*/  
FROM  
(  
    SELECT "欄位1"  
          ,"欄位2"  
          ,"欄位3"  
          ,"條件欄位"  
          ,"要統計的欄位"  
    FROM "表格名稱"  
) AS "SOURCE"  
PIVOT  
(  
    SUM("要統計的欄位") /**彙總函式*/  
    FOR "條件欄位" IN ("A","B","C","D") /**轉置後的欄位,即條件欄位的值*/  
) AS "PIVOT_COLUMN"

sql — 2017年12月26日