
查询所有子节点
- 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;
复制代码
查询所有父节点调换颜色部分 |