Solution:Step 1: Identify manager of employee 5The subquery finds the manager_id of employee with emp_id = 5.Step 2: Select employees with same manager excluding employee 5Main query selects employees with that manager_id but excludes emp_id 5.Step 3: Check other optionsSELECT name FROM employees WH

[Solved] Given tables:employees(emp_id, name, manager_id)Write a query to find employees who have the same manager as employee with emp_id = 5. Which query correctly uses a subquery in the WHERE clause? | SQL

SQL - Subqueries

Given tables:
employees(emp_id, name, manager_id)
Write a query to find employees who have the same manager as employee with emp_id = 5. Which query correctly uses a subquery in the WHERE clause?

ASELECT name FROM employees WHERE manager_id = (SELECT manager_id FROM employees WHERE emp_id = 5) AND emp_id != 5;

BSELECT name FROM employees WHERE emp_id IN (SELECT emp_id FROM employees WHERE manager_id = 5);

CSELECT name FROM employees WHERE manager_id IN (SELECT emp_id FROM employees WHERE emp_id = 5);

DSELECT name FROM employees WHERE manager_id = 5;

Step-by-Step Solution

Solution:

Step 1: Identify manager of employee 5
The subquery finds the manager_id of employee with emp_id = 5.
Step 2: Select employees with same manager excluding employee 5
Main query selects employees with that manager_id but excludes emp_id 5.
Step 3: Check other options
SELECT name FROM employees WHERE emp_id IN (SELECT emp_id FROM employees WHERE manager_id = 5); incorrectly uses emp_id in subquery. SELECT name FROM employees WHERE manager_id IN (SELECT emp_id FROM employees WHERE emp_id = 5); mismatches columns. SELECT name FROM employees WHERE manager_id = 5; selects employees managed by 5, not same manager as 5.
Final Answer:
SELECT name FROM employees WHERE manager_id = (SELECT manager_id FROM employees WHERE emp_id = 5) AND emp_id != 5; -> Option A
Quick Check:
Subquery finds manager_id to filter employees [OK]

Quick Trick: Use subquery to find manager_id, then filter employees by it [OK]

Common Mistakes:

MISTAKES

Confusing manager_id with emp_id in subquery
Not excluding employee 5 from results
Using IN incorrectly with emp_id

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given tables:

Step 1: Identify manager of employee 5

Step 2: Select employees with same manager excluding employee 5

Step 3: Check other options

Final Answer:

Quick Check:

Want More Practice?