使用DB2的with as 语句 实现树的递归查询

本篇文章主要介绍了"使用DB2的with as 语句 实现树的递归查询"，主要涉及到递归查询,with方面的内容，对于DB2感兴趣的同学可以参考一下： WITH n(brno) AS (SELECT brno FROM org_bctlWHERE brno = 11010UNION ALLSELECT nplu...

WITH n(brno) AS 
   (SELECT brno 
      FROM org_bctl
      WHERE brno = '11010'
    UNION ALL
    SELECT nplus1.brno
      FROM org_bctl as nplus1, n
      WHERE n.brno = nplus1.sbrno)
select * from n

以上就介绍了使用DB2的with as 语句 实现树的递归查询，包括了递归查询,with方面的内容，希望对DB2有兴趣的朋友有所帮助。

本文网址链接：http://www.codes51.com/article/detail_1286838.html