关于Oracle、SqlServer 的sql递归查询

递归查询所有子节点

• oracle

             SELECT * FROM hrmdepartment
             START WITH  id=22
             CONNECT BY PRIOR id=supdepid

• sqlserver

             with result_table as 
             ( 
                select a.id,a.lastname,a.managerid from hrmresource a where id=321 
                union all  
                select k.id,k.lastname,k.managerid  from hrmresource k inner join result_table c on c.id = k.managerid 
              )select * from result_table

关于Oracle、SqlServer 的sql递归查询

原文：http://www.cnblogs.com/JsonShare/p/5120585.html