|
WITH t(a, b) AS ( SELECT 'C0001', '사과' FROM dual UNION ALL SELECT 'C0001', '배' FROM dual UNION ALL SELECT 'D0001', '복숭아' FROM dual UNION ALL SELECT 'E0001', '딸기' FROM dual UNION ALL SELECT 'E0001', '배' FROM dual ) SELECT a , SUBSTR(MIN(DECODE(rn,1,','||b)) ||MIN(DECODE(rn,2,','||b)) ,2) FROM (SELECT t.* , ROW_NUMBER() OVER (PARTITION BY a ORDER BY NULL) rn FROM t ) GROUP BY a