FROM op_client_sales_structure team
WHERE Parentid !=-1
UNION ALL
SELECT a.id,a.position,a.Parentid,
CTE.PATH+','+Cast(a.Parentid AS NVARCHAR(4000)) AS PATH
FROM op_client_sales_structure a
INNER JOIN TEST_CTE CTE ON a.id=CTE.Parentid
)
SELECT * FROM TEST_CTE WHERE Parentid=(SELECT id FROM op_client_sales_structure WHERE Parentid=-1)
--限制递归次数
OPTION(MAXRECURSION 10)
这篇文章就介绍到这，希望能帮助到你。
您可能感兴趣的文章:SQL Server 通过with as方法查询树型结构
