Intermediate
SQL
Q43 / 100
What does a self-join allow you to do?
Correct! Well done.
Incorrect.
The correct answer is A) Join a table with itself, often using aliases, to compare rows within the same table
A
Correct Answer
Join a table with itself, often using aliases, to compare rows within the same table
Explanation
A self-join treats the same table as two separate instances (via aliases) to compare or relate rows to other rows in the same table, e.g. finding employees and their managers.
Progress
43/100