← 🗃️ SQL Deep Dive21 / 25
Lesson 21 — Self join
Join a table to itself
Compare rows within one table — like employees and their managers.
Why it matters: hierarchies live in a single table.
Task
Pair each employee with their manager name.
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.