최상위 코드와 그 최상위 코드를 대상으로 그룹 .

[감리 산출물 작업]

select A.COMM_CD,A.COMM_NM,A.UP_COMM_CD, B.COMM_NM,A.USE_YN

from COM_STD_MGT A INNER JOIN 

(

     SELECT COMM_CD,COMM_NM,UP_COMM_CD FROM COM_STD_MGT WHERE UP_COMM_CD='300'

) B ON (A.UP_COMM_CD = B.COMM_CD)

WHERE A.USE_YN ='Y'

ORDER BY UP_COMM_CD,COMM_CD;

                                                                  ▽

select   A.UP_COMM_CD AS 최상위코드,  B.COMM_NM AS 최상위코드네임 ,A.COMM_CD AS 하위코드,A.COMM_NM AS 하위코드네임,A.USE_YN AS 사용유무

from COM_STD_MGT A INNER JOIN 

(

     SELECT COMM_CD,COMM_NM,UP_COMM_CD FROM COM_STD_MGT WHERE UP_COMM_CD='200'   -- UP_COMM_CD 의 값에 최상위 코드를 입력 할것 

) B ON (A.UP_COMM_CD = B.COMM_CD)

WHERE A.USE_YN ='Y'

ORDER BY A.UP_COMM_CD,A.COMM_CD ;

  -- 검색후 엑셀로 추출 하여 필터 처리 하여 감리 산출물에 반영 할것 BY 김훈