[jami] - for the better

계층구조 쿼리에 사용.참조 : http://msdn.microsoft.com/en-us/library/ms186243%28v=sql.105%29.aspx sampleWITH CTE_AE_CODE_H AS ( SELECT * , 0 AS LEVEL , CAST(RANK AS DECIMAL(20)) AS SORT --소팅(문자열로 변환 후 소팅해야 함) , CAST(CODE_NAME AS VARCHAR(1000)) AS CODE_PATH FROM IAMS.DBO.AE_CODE_H WHERE 1 = 1 AND UP_CODE_ID = '*' --AND UP_CODE_ID = 'ROOT_ASSET_TYPE' UNION ALL SELECT A.* , R.LEVEL + 1 AS LEVEL , CAST(R.SORT *..

출처 : http://www.psoug.org/reference/connectby.html 다음 내용은 최신버전이 아닐 수 있습니다. 최신의 글은 위 사이트를 참조하세요. Syntax 1 CONNECT BY [NOCYCLE] START WITH Syntax 2 START WITH CONNECT BY [NOCYCLE] CONNECT BY PRIOR A condition that identifies the relationship between parent rows and child rows of the hierarchy CONNECT BY = conn hr/hr SELECT employee_id, last_name, manager_id FROM employees CONNECT BY PRIOR employee..