SQL 递归枚举子树
示例
WITH RECURSIVE ManagedByJames(Level, ID, FName, LName) AS (
-- start with this row
SELECT 1, ID, FName, LName
FROM Employees
WHERE ID = 1
UNION ALL
-- get employees that have any of the previously selected rows as manager
SELECTManagedByJames.Level+ 1,
Employees.ID,
Employees.FName,
Employees.LName
FROM Employees
JOIN ManagedByJames
ONEmployees.ManagerID= ManagedByJames.ID
ORDER BY 1 DESC -- depth-first search
)
SELECT * FROM ManagedByJames;热门推荐
10 结婚新娘妈妈祝福语简短
11 元旦祝福语的英文简短
12 高寿生日祝福语简短独特
13 送米的祝福语简短
14 写给宝宝新年祝福语简短
15 亲人喜得贵子祝福语简短
16 情侣结婚的祝福语简短
17 爸妈对宝宝祝福语简短
18 学生老师离职祝福语简短