Self-Joins

Back to Joins

A join where a table is joined with itself, typically using aliases. Useful for hierarchical data or comparing rows within the same table.

relational-databases sql joins