areaName
-
sql查询树状结构某节点下的所有子节点
with cte_child(id,areaName,pid,level)as( –起始条件 select id,areaName,pid,0 as level fro…
-
sql 查询树状结构某节点(44)的上级所有根节点
with cte_child(id,areaName,pid) as ( –起始条件 select id,areaName,pid from erp_area wher…
with cte_child(id,areaName,pid,level)as( –起始条件 select id,areaName,pid,0 as level fro…
with cte_child(id,areaName,pid) as ( –起始条件 select id,areaName,pid from erp_area wher…