← 🗃️ SQL Deep Dive23 / 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.
Task
Print each category with its depth.
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.