Lesson 5.9 · Pro
Recursive CTE: walk a hierarchy (optional)
Follow manager links up or down an org chart, any number of levels deep.
In this lesson
- A CTE that refers to itself
- Walk down from the top
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.