表格直橫互轉
直轉橫 技巧：SUM() + DECODE() 範例： id fee amt date 1 01 20 2021-01-01 1 02 30 2021-01-01 2 01 25 2021-01-01 1 01 15 2021-01-02 2 02 40 2021-01-02 1 03 50 2021-01-03 SELECT id ,SUM(DECODE(fee,'01',amt,0)) AS fee01 ,SUM(DECODE(fee,'02',amt,0)) AS fee02 ,SUM(DECODE(fee,'03',amt,0)) AS fee03 FROM t1 GROUP BY 1 ; id fee01 fee02 fee03 1 35 20 50 2 25 40 0