Recursive 사용 예시

 

WITH RECURSIVE hierarchys AS (
	SELECT IPG1.*
    FROM IF_PRODUCT_GRP AS IPG1
    WHERE PRD_GRP_CD IN ('HCWCHB')
    UNION
    SELECT IPG2.*
    FROM IF_PRODUCT_GRP AS IPG2
    INNER JOIN herarcys h
    ON IPG2.PRD_GRP_CD = h.UPPER_PRD_CD
)
SELECT * FROM hierarchys GROUP BY PRD_GRP_CD ORDER BY PRD_GRP_LEVEL ASC;