SQL Server 父子迭代查询语句,树状查询
-- 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 INNER JOIN Tree T ON C.ParentId = T.Id ) SELECT * FROM Tree -- Get parents by child id WITH Tree AS ( SELECT Id,ParentId FROM dbo.Node C WHERE C.Id = 57 -- child id UNION ALL SELECT P.Id,P.ParentId FROM dbo.Node P INNER JOIN Tree T ON P.Id = T.ParentId ) SELECT * FROM Tree
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步