例如查询父节点为2的 子节点的uid
像如下的这种语法支持吗?
with cte as(select a.uid from subreleation a where parentId='2'
union all select k.uid from subreleation k inner join cte c on c.uid = k.parentId)
select * from cte
例如查询父节点为2的 子节点的uid
像如下的这种语法支持吗?
with cte as(select a.uid from subreleation a where parentId='2'
union all select k.uid from subreleation k inner join cte c on c.uid = k.parentId)
select * from cte