摘要：
DB2反向递归拿到所有部门WITH ROOT ( CODE, CUSTOM_CODE, FULL_NAME, ID, NAME, PARENT_CODE, PY_CODE, LEVEL, PARENT_NAME) AS ( SELECT A.CODE, A.CUSTOM_CODE, A.FULL_NAME, A.ID, A.NAME, A.PARENT_CODE, A.PY_CODE, A.LEVEL, A.PARENT_NAME FROM VIEW_INST_DEPART_CLASSIFY_LEVEL A WHERE A.CODE IN ( SELECT DISTINCT B.DEPARTM 阅读全文
