[SQL] 하위부서를 구하는 쿼리

   WITH TMP AS
    (
        SELECT * FROM TEST
        WHERE TEST_ID = '1360'

       UNION ALL



       SELECT TD.* FROM TEST TD, TMP TP
        WHERE TD.P_TEST_ID = TP.TEST_ID
    )
    SELECT TEST_ID  FROM TMP;