sql的树形结构遍历所有子节点

sqlServer树形查询

with f as 
(
select * from view_zz where TEAM='90'
union all
select a.* from view_zz as a inner join f as b on a.DEP_PARENTID=b.TEAM
)
select * from f

oracle树形查询所有子节点

SELECT a.*,org_name
           FROM SY_ORGANIZATION a
          START WITH a.org_id in
                     ('10000013')
         CONNECT BY PRIOR a.org_id = a.parent_id;

oracle查询所有父节点（当org_type = 1 时）

select s.*,s.org_name from sy_organization s 
   where s.org_type = 1 
     start with s.org_id = 10002424  
     connect by  prior s.parent_id = s.org_id ;