Lesson 5.6 · Pro
Self join: a table joined to itself
Compare rows in the same table, like employees with their managers or pairs of users.
In this lesson
- Join a table to itself
- Compare a row with its partner
- Find pairs in the same table
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.