WITH T AS (
SELECT '남1호' EMP_NM , 'AAAAAAAAAA' COUNSEL_NM , '2014-05' PLAN_YM, 10 AMT FROM DUAL UNION ALL
SELECT '남1호' EMP_NM , 'BBBBBBBBBB' COUNSEL_NM , '2014-06' PLAN_YM, 20 AMT FROM DUAL UNION ALL
SELECT '남1호' EMP_NM , 'CCCCCCCCCC' COUNSEL_NM , '2014-06' PLAN_YM, 30 AMT FROM DUAL UNION ALL
SELECT '여1호' EMP_NM , 'DDDDDDDDDD' COUNSEL_NM , '2014-05' PLAN_YM, 10 AMT FROM DUAL UNION ALL
SELECT '여1호' EMP_NM , 'EEEEEEEEEE' COUNSEL_NM , '2014-05' PLAN_YM, 20 AMT FROM DUAL UNION ALL
SELECT '여1호' EMP_NM , 'FFFFFFFFFF' COUNSEL_NM , '2014-05' PLAN_YM, 30 AMT FROM DUAL UNION ALL
SELECT '여1호' EMP_NM , 'GGGGGGGGGG' COUNSEL_NM , '2014-05' PLAN_YM, 40 AMT FROM DUAL UNION ALL
SELECT '여1호' EMP_NM , 'HHHHHHHHHH' COUNSEL_NM , '2014-05' PLAN_YM, 50 AMT FROM DUAL
)
SELECT
EMP_NM
, CASE PLAN_YM WHEN '2014-04' THEN COUNSEL_NM END COUNS04
, CASE PLAN_YM WHEN '2014-04' THEN SUM(AMT) END AMT04
, CASE PLAN_YM WHEN '2014-05' THEN COUNSEL_NM END COUNS05
, CASE PLAN_YM WHEN '2014-05' THEN SUM(AMT) END AMT05
, CASE PLAN_YM WHEN '2014-06' THEN COUNSEL_NM END COUNS06
, CASE PLAN_YM WHEN '2014-06' THEN SUM(AMT) END AMT06
FROM T
GROUP BY EMP_NM, COUNSEL_NM, PLAN_YM
상기 쿼리 결과 -->
EMP_NM COUNS04 AMT04 COUNS05 AMT05 COUNS06 AMT06
남1호 AAAAAAAAAA 10
남1호 BBBBBBBBBB 20
남1호 CCCCCCCCCC 30
여1호 DDDDDDDDDD 10
여1호 EEEEEEEEEE 20
여1호 FFFFFFFFFF 30
여1호 GGGGGGGGGG 40
여1호 HHHHHHHHHH 50
EMP_NM COUNS04 AMT04 COUNS05 AMT05 COUNS06 AMT06
남1호 AAAAAAAAAA 10 BBBBBBBBBB 20
남1호 CCCCCCCCCC 30
여1호 DDDDDDDDDD 10
여1호 EEEEEEEEEE 20
여1호 FFFFFFFFFF 30
여1호 GGGGGGGGGG 40
여1호 HHHHHHHHHH 50
조언을 부탁드립니다.