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 语句 实现树的递归查询
最新推荐文章于 2024-09-08 22:53:03 发布