查詢所有子節點 查詢所有父節點調換顏色部分 ...
查詢所有子節點
with Select_child(id,parentId,value,level) as( select id,parentid,value,0 as level from ctable where parentid=2 union all select c.id,c.parentid,c.value,sc.level+1 from ctable c inner join Select_child sc on c.parentId=sc.id ) select * from Select_child;
查詢所有父節點調換顏色部分