LISTAGG\ub97c \uc0ac\uc6a9\ud574\uc11c JOHN,LEE,SMITH,LEE,PARK,LEE \ud615\uc2dd\uc73c\ub85c \ub370\uc774\ud130\ub97c \ub9cc\ub4e4\uc218 \uc788\ub2e4.
\n\uc911\uac04\uc5d0 LEE \uac12\uc744 \uc911\ubcf5\uc81c\uac70\ub97c \ud558\ub824\uba74 REGEXP_REPLACE(CONTENTS,'([^,]+)(,\\1)+’, ‘\\1’) \ub97c \uc0ac\uc6a9\ud574\uc11c \uc911\ubcf5\uc81c\uac70\ub97c \ubf51\uc544\ub0b4\uc790.<\/p>\n
SELECT
\n DEPTNO
\n ,LISTAGG(EMPNO, ‘,’) WITHIN GROUP (ORDER BY ROWNUM) AS ORIGINAL_DATA
\n ,REGEXP_REPLACE(
\n LISTAGG(EMPNO, ‘,’) WITHIN GROUP (ORDER BY ROWNUM)
\n ,'([^,]+)(,\\1)+’, ‘\\1′) AS REMOVE_DUPLICATE_DATA
\n — REGEXP_REPLACE(CONTENTS,'([^,]+)(,\\1)+’, ‘\\1’) — REMOVE THE DUPLICATE
\nFROM EMP_DATA
\nGROUP BY DEPTNO<\/p>\n
\ub9cc\uc57d\uc5d0 WM_CONCAT\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4\uba74 \uac04\ub2e8\ud558\uac8c \uc544\ub798\uc640 \uac19\uc774 DISTINCT\ub97c \uc9d1\uc5b4\ub123\uc73c\uba74 \ub41c\ub2e4.<\/p>\n
SELECT
\n DEPTNO
\n ,wm_concat(name) names
\n ,wm_concat(DISTINCT name) REMOVE_DUPLICATE_names
\nFROM EMP_DATA
\nGROUP BY DEPTNO<\/p>\n","protected":false},"excerpt":{"rendered":"
LISTAGG\ub97c \uc0ac\uc6a9\ud574\uc11c JOHN,LEE,SMITH,LEE,PARK,LEE \ud615\uc2dd\uc73c\ub85c \ub370\uc774\ud130\ub97c \ub9cc\ub4e4\uc218 \uc788\ub2e4. \uc911\uac04\uc5d0 LEE \uac12\uc744 \uc911\ubcf5\uc81c\uac70\ub97c \ud558\ub824\uba74 REGEXP_REPLACE(CONTENTS,'([^,]+)(,\\1)+’, ‘\\1’) \ub97c \uc0ac\uc6a9\ud574\uc11c \uc911\ubcf5\uc81c\uac70\ub97c \ubf51\uc544\ub0b4\uc790. SELECT DEPTNO ,LISTAGG(EMPNO, ‘,’) WITHIN GROUP (ORDER BY ROWNUM) AS ORIGINAL_DATA ,REGEXP_REPLACE( LISTAGG(EMPNO, ‘,’) WITHIN GROUP (ORDER BY ROWNUM) ,'([^,]+)(,\\1)+’, ‘\\1′) AS REMOVE_DUPLICATE_DATA — REGEXP_REPLACE(CONTENTS,'([^,]+)(,\\1)+’, ‘\\1’) — REMOVE THE DUPLICATE FROM EMP_DATA GROUP BY DEPTNO \ub9cc\uc57d\uc5d0 WM_CONCAT\uc744 … Continue reading LISTAGG AND DISTINCT<\/span>