-- 查找树的所有子节点
with cte as
(select Id,Pid,Name from dc_trees where pid=2
union all
select t.id,t.pid,t.Name from cte a,dc_trees t where t.pid=a.id)
select * from cte
james641 2016-01-06 15:18 原文
-- 查找树的所有子节点
with cte as
(select Id,Pid,Name from dc_trees where pid=2
union all
select t.id,t.pid,t.Name from cte a,dc_trees t where t.pid=a.id)
select * from cte