数据表查询所有子/父节点
查询所有子节点
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;
查询所有父节点调换颜色部分
--------------------------------------------------------------------------------------------------------------------------------------------
作者:Honey_Badger —— 觉得这文章好,点一下左下角
出处:http://tk55.cnblogs.com/
posted on 2018-04-14 12:32 Honey_Badger 阅读(552) 评论(2) 编辑 收藏 举报