← 🗃️ SQL Deep Dive
23 / 25
Lesson 23 — Recursive hierarchy with depth
Walk a tree and count levels
A recursive CTE can carry a depth counter as it descends a hierarchy.
Why it matters: org charts and category trees need level info.
Not clear enough?
Task
Print each category with its depth.
🧠 Test your knowledge
A quick 3-question quiz on this lesson — instant feedback.
Keep going with SQL Deep Dive
Ready for more? These paid resources pick up where this lesson leaves off.
UdemyBestsellers
Top-rated SQL Deep Dive courses
Project-based SQL Deep Dive video courses — the perfect paid next step after these free lessons.
Browse on Udemy →AmazonReader picks
Best SQL Deep Dive books
Hand-picked SQL Deep Dive books to master the fundamentals offline.
See on Amazon →Some links on this page are affiliate links: we may earn a commission at no extra cost to you. We only recommend tools we believe are genuinely useful.