WITH AA AS
(SELECT 2018, 1,' 72102','AAA', '41101A ',10000
FROM DUAL
UNION ALL
SELECT 2018, 2,' 72102','AAA', '41101A ',10000
FROM DUAL
UNION ALL
SELECT 2018, 3,' 72102','AAA', '41101A ',10000
FROM DUAL
UNION ALL
SELECT 2018, 4,' 72102','AAA', '41101A ',10000
FROM DUAL
UNION ALL
SELECT 2018, 5,' 72102','AAA', '41101A ',10000
FROM DUAL
UNION ALL
SELECT 2018, 6,' 72102','AAA', '41101A ',10000
FROM DUAL
UNION ALL
SELECT 2018, 7,' 72102','AAA', '41101A ',10000
FROM DUAL
UNION ALL
SELECT 2018, 8,' 72102','AAA', '41101A ',10000
FROM DUAL
UNION ALL
SELECT 2018, 9,' 72102','AAA', '41101A ',10000
FROM DUAL
UNION ALL
SELECT 2018, 10,' 72102','AAA', '41101A ',10000
FROM DUAL
UNION ALL
SELECT 2018, 11,' 72102','AAA', '41101A ',10000
FROM DUAL
UNION ALL
SELECT 2018, 12,' 72102','AAA', '41101A ',10000
FROM DUAL
)
SELECT * FROM AA;
WITH AA (CFY, PN, MCU, SBL, R021, AMOUNT) AS ( SELECT 2018, 1, '72102','AAA', '41101A',10000 FROM DUAL UNION ALL SELECT 2018, 2, '72102','AAA', '41101A',10000 FROM DUAL UNION ALL SELECT 2018, 3, '72102','AAA', '41101A',10000 FROM DUAL UNION ALL SELECT 2018, 4, '72102','AAA', '41101A',10000 FROM DUAL UNION ALL SELECT 2018, 5, '72102','AAA', '41101A',10000 FROM DUAL UNION ALL SELECT 2018, 6, '72102','AAA', '41101A',10000 FROM DUAL UNION ALL SELECT 2018, 7, '72102','AAA', '41101A',10000 FROM DUAL UNION ALL SELECT 2018, 8, '72102','AAA', '41101A',10000 FROM DUAL UNION ALL SELECT 2018, 9, '72102','AAA', '41101A',10000 FROM DUAL UNION ALL SELECT 2018, 10,'72102','AAA', '41101A',10000 FROM DUAL UNION ALL SELECT 2018, 11,'72102','AAA', '41101A',10000 FROM DUAL UNION ALL SELECT 2018, 12,'72102','AAA', '41101A',10000 FROM DUAL ) SELECT CFY , MCU , SBL , R021 , SUM(CASE WHEN PN = 1 THEN AMOUNT END ) AMOUNT_1 -- 월 , SUM(CASE WHEN PN = 2 THEN AMOUNT END ) AMOUNT_2 , SUM(CASE WHEN PN = 3 THEN AMOUNT END ) AMOUNT_3 , SUM(CASE WHEN PN = 4 THEN AMOUNT END ) AMOUNT_4 , SUM(CASE WHEN PN = 5 THEN AMOUNT END ) AMOUNT_5 , SUM(CASE WHEN PN = 6 THEN AMOUNT END ) AMOUNT_6 , SUM(CASE WHEN PN = 7 THEN AMOUNT END ) AMOUNT_7 , SUM(CASE WHEN PN = 8 THEN AMOUNT END ) AMOUNT_8 , SUM(CASE WHEN PN = 9 THEN AMOUNT END ) AMOUNT_9 , SUM(CASE WHEN PN = 10 THEN AMOUNT END ) AMOUNT_10 , SUM(CASE WHEN PN = 11 THEN AMOUNT END ) AMOUNT_11 , SUM(CASE WHEN PN = 12 THEN AMOUNT END ) AMOUNT_12 , SUM(CASE WHEN PN IN ( 1, 2, 3 ) THEN AMOUNT END ) AMOUNT_Q1 -- 분기 , SUM(CASE WHEN PN IN ( 4, 5, 6 ) THEN AMOUNT END ) AMOUNT_Q2 , SUM(CASE WHEN PN IN ( 7, 8, 9 ) THEN AMOUNT END ) AMOUNT_Q3 , SUM(CASE WHEN PN IN ( 10, 11, 12) THEN AMOUNT END ) AMOUNT_Q3 , SUM(AMOUNT) TOT_AMOUNT -- 전체 FROM AA GROUP BY CFY , MCU , SBL , R021