[Solved] What will the following query return?SELECT emp.name AS Employee, mgr.name AS Manager FROM employees emp INNER JOIN employees mgr ON emp.manager_id = mgr.id; | SQL

SQL - INNER JOIN

Consider the table employees(id, name, manager_id). What will the following query return?

SELECT emp.name AS Employee, mgr.name AS Manager FROM employees emp INNER JOIN employees mgr ON emp.manager_id = mgr.id;

AOnly managers who have no employees

BAll employees including those without managers

CPairs of employees and their respective managers

DEmployees who do not have a manager

Step-by-Step Solution

Solution:

Step 1: Analyze the join condition
The query joins the table to itself where emp.manager_id = mgr.id, linking employees to their managers.
Step 2: Understand INNER JOIN effect
INNER JOIN returns only rows where the join condition matches, so employees without managers are excluded.
Final Answer:
Pairs of employees and their respective managers -> Option C
Quick Check:
INNER JOIN excludes employees without managers [OK]

Quick Trick: INNER JOIN excludes unmatched rows [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Consider the table employees(id, name, manager_id). What will the following query return?