db2数据库递归查询

DB2数据库
<select id="selectOrgId" resultType="java.lang.String" parameterType="org.yatop.sysManage.userManage.info.SysUser">
        WITH RPL (ORG_ID,F_ORG_ID,ORG_NM) AS 
        (SELECT ORG_ID,F_ORG_ID,ORG_NM FROM SYS_ORG WHERE ORG_ID = #{orgId,jdbcType=VARCHAR}
          UNION ALL 
          SELECT child.ORG_ID,child.F_ORG_ID,child.ORG_NM FROM RPL parent,SYS_ORG child WHERE parent.ORG_ID=child.F_ORG_ID
        )
        SELECT * FROM RPL
    </select>

 

转载于:https://www.cnblogs.com/bingrong/p/7238172.html