sqlserver with递归向下遍历语句
WITH xx AS
(SELECT * FROM 表 WHERE pid = ‘需要向下遍历的节点ID’
UNION ALL
SELECT 表.* FROM xx JOIN 表 ON xx .id = 表.pid)
SELECT * FROM xx
sqlserver with递归向下遍历语句
WITH xx AS
(SELECT * FROM 表 WHERE pid = ‘需要向下遍历的节点ID’
UNION ALL
SELECT 表.* FROM xx JOIN 表 ON xx .id = 表.pid)
SELECT * FROM xx