Oracle/Sqlserver递归查询

1.Oracle递归查询

 2.SqlServer递归查询

 with cte as 
 ( 
 select t.id,t.name,t.parentId from dbo.Department t where t.id='2' 
 union all  
 select k.id,k.name,k.parentId  from dbo.Department k inner join cte c on c.id = k.parentId 
 )select * from cte