오라클
최상위 코드와 그 최상위 코드를 대상으로 그룹 .
사라링
2012. 8. 24. 14:12
[감리 산출물 작업]
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 김훈