1
SQLIntermediate#aggregates
SQLIntermediate#joins
What is a SELF JOIN?
Joining a table to itself using two aliases, typically to walk a hierarchy stored in the same table.
Example
SELECT e.name AS employee, m.name AS manager FROM employees e JOIN employees m ON e.manager_id = m.id;