WITH t AS
(
SELECT '김철수' empno, '201411' yymm, 100 korea, 90 english FROM dual
UNION ALL SELECT '김철수', '201412', 100, 90 FROM dual
UNION ALL SELECT '김철수', '201501', 100, 90 FROM dual
UNION ALL SELECT '김철수', '201502', 100, 90 FROM dual
UNION ALL SELECT '이영호', '201412', 100, 90 FROM dual
UNION ALL SELECT '이영호', '201501', 100, 90 FROM dual
UNION ALL SELECT '이영호', '201502', 100, 90 FROM dual
UNION ALL SELECT '박수영', '201411', 100, 90 FROM dual
UNION ALL SELECT '박수영', '201412', 100, 90 FROM dual
)
SELECT empno
     , MIN(DECODE(yymm, '201411', yymm   ))    yymm_201411
     , MIN(DECODE(yymm, '201411', korea  ))   korea_201411
     , MIN(DECODE(yymm, '201411', english)) english_201411
     , MIN(DECODE(yymm, '201412', yymm   ))    yymm_201412
     , MIN(DECODE(yymm, '201412', korea  ))   korea_201412
     , MIN(DECODE(yymm, '201412', english)) english_201412
     , MIN(DECODE(yymm, '201501', yymm   ))    yymm_201501
     , MIN(DECODE(yymm, '201501', korea  ))   korea_201501
     , MIN(DECODE(yymm, '201501', english)) english_201501
     , MIN(DECODE(yymm, '201502', yymm   ))    yymm_201502
     , MIN(DECODE(yymm, '201502', korea  ))   korea_201502
     , MIN(DECODE(yymm, '201502', english)) english_201502
  FROM t
 GROUP BY empno
;

마농님

답변 감사드립니다.

그런데 제가 설명에서 빼놓은 부분이 있었네요...

이 테이블에서 지정된 4개월만 옆으로 나열하는것이 아니고,

where절의 시작년월과 종료년월이 파라미터로 넘겨 받는 것이라

기간이 4달이 될수 있고, 6달, 12달도 될 수 있는 상황입니다.

그래서 정해진 열만큼 decode를 쓸 수 있는 것이 아니라서 임의의 년월에 해당하는 만큼

decode를 쓸 수 있는지를 질문 드린다는게 잘못올렸네요...

WITH T AS
(SELECT '김철수' AS EMPNO, '201411' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '김철수' AS EMPNO, '201412' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '김철수' AS EMPNO, '201501' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '김철수' AS EMPNO, '201502' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '이영호' AS EMPNO, '201412' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '이영호' AS EMPNO, '201501' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '이영호' AS EMPNO, '201502' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '박수영' AS EMPNO, '201411' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '박수영' AS EMPNO, '201412' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 
 
 SELECT '박수영' AS EMPNO, '201504' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '박수영' AS EMPNO, '201506' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '박수영' AS EMPNO, '201507' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '박수영' AS EMPNO, '201508' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '박수영' AS EMPNO, '201509' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '김철수' AS EMPNO, '201504' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '김철수' AS EMPNO, '201506' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL UNION ALL
 SELECT '김철수' AS EMPNO, '201507' AS YYMM, '100' AS KOREA, '90' AS ENGLISH FROM DUAL

)

SELECT * FROM T
WHERE YYMM >= '201411'
AND YYMM <= '201502'

쿼리만으로 해결할 수 있는 문제가 아닙니다.
프로그램에서 해당 월만큼 루프 돌려가면서
동적으로 위의 쿼리 문장을 완성하신 뒤
완성된 SQL을 실행하셔야 합니다.

네 쿼리로는 안되겠군요..

답변 감사드립니다.