WITH T AS ( SELECT 'A' GUBUN , '한국' NATION, '11/20' DT FROM DUAL UNION ALL SELECT 'A' GUBUN , '일본' NATION, '11/21' DT FROM DUAL UNION ALL SELECT 'B' GUBUN , '한국' NATION, '11/22' DT FROM DUAL UNION ALL SELECT 'B' GUBUN , '일본' NATION, '11/23' DT FROM DUAL ) SELECT GUBUN 구분 ,MIN(DECODE(NATION,'한국',DT)) 한국 ,MIN(DECODE(NATION,'일본',DT)) 일본 FROM T GROUP BY GUBUN