WITH RECURSIVE TMP AS ( -- 최상위 부모 정의 SELECT COD , NM , 1 AS LVL , CAST(COD AS VARCHAR(100)) AS PATH , CAST(NM AS VARCHAR(100)) AS PATHNM FROM CODTEST WHERE PARNT = '' UNION ALL -- 단계별 부모와 자식 매핑 SELECT C.COD , C.NM , P.LVL + 1 AS LVL , CONCAT(P.PATH , ' > ', C.COD) AS PATH , CONCAT(P.PATHNM, ' > ', C.NM) AS PATHNM FROM TMP AS P JOIN CODTEST AS C ON C.PARNT = P.COD ) SELECT * FROM TMP MySQL에서도 CON..
