WITH t AS (
SELECT * FROM Sys_Basic_Project_Category_Tree WHERE ID = 2
UNION ALL
SELECT a.* FROM Sys_Basic_Project_Category_Tree a
JOIN t b ON a.Parent_ID = b.ID
)
SELECT ID FROM t WHERE ID<>2
通过上述sql语句,可以查询到Id=2的节点的所有子节点列表信息。
SELECT * FROM Sys_Basic_Project_Category_Tree WHERE ID = 2
UNION ALL
SELECT a.* FROM Sys_Basic_Project_Category_Tree a
JOIN t b ON a.Parent_ID = b.ID
)
SELECT ID FROM t WHERE ID<>2
通过上述sql语句,可以查询到Id=2的节点的所有子节点列表信息。