数据表查询所有子/父节点

小贝

查询所有子节点

1. with Select_child(id,parentId,value,level)
2. as(
3. select id,parentid,value,0 as level from ctable where parentid=2
4. union all
5. select c.id,c.parentid,c.value,sc.level+1 from ctable c
6. inner join Select_child sc on c.parentId=sc.id
7. )
9. select * from Select_child;

复制代码

查询所有父节点调换颜色部分