[Oracle] LISTAGG

• LISTAGG 예제

  SELECT COUNTRY
         , LISTAGG(RATE,',') WITHIN GROUP(ORDER BY EXCHG_RATE_DATE DESC) AS RATE
    FROM EXCHANGE_RATE_INFO_TB
GROUP BY COUNTRY;

• 결과

---

• LISTAGG 중복데이터 제거 예제

  SELECT COUNTRY
         , REGEXP_REPLACE(LISTAGG(RATE,',') WITHIN GROUP(ORDER BY EXCHG_RATE_DATE DESC), '([^,]+)(,\1)+', '\1') AS RATE
    FROM EXCHANGE_RATE_INFO_TB
GROUP BY COUNTRY;

• 결과