表格直橫互轉

 直轉橫

技巧：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