-- Get childs by parent id
WITH Tree
AS
(
SELECT Id,ParentId FROM dbo.Node P WHERE P.Id = 21 -- parent id
UNION ALL
SELECT C.Id,C.ParentId FROM dbo.Node C
SQL Server 父子迭代查询语句,树状查询
最新推荐文章于 2023-05-04 11:44:27 发布
-- Get childs by parent id
WITH Tree
AS
(
SELECT Id,ParentId FROM dbo.Node P WHERE P.Id = 21 -- parent id
UNION ALL
SELECT C.Id,C.ParentId FROM dbo.Node C