Beginner
Database Management Systems
Q34 / 100
What is a self-join?
Correct! Well done.
Incorrect.
The correct answer is B) A join where a table is joined to itself, typically to compare rows within the same table or find hierarchical relationships
B
Correct Answer
A join where a table is joined to itself, typically to compare rows within the same table or find hierarchical relationships
Explanation
Self-join: SELECT e.name AS employee, m.name AS manager FROM employees e JOIN employees m ON e.manager_id = m.id — finds each employee's manager from the same employees table.
Progress
34/100