db2 递归函数小示例
with rpl(id,name,parent) as (
select id,name,parent from A_ORGAN where id=999
union all
select t1.id,t1.name,t1.parentfrom rpl t2,A_ORGAN t1 where t2.id=t1.parent
)
selectdistinct id,name,parent from rpl order by id asc
?
select t1.id,t1.name from A_ORGANt1 where ?t1.ID=999 or t1.PARENT=999 order by t1.id asc
