[Solved] Which of the following is the correct way to write a subquery with the IN operator in SQL? — Ans: SELECT name FROM Employees WHERE dept_id IN (SELECT dept_id FROM Departments); | SQL

SQL - Subqueries

Which of the following is the correct way to write a subquery with the IN operator in SQL?

ASELECT name FROM Employees WHERE dept_id = IN (SELECT dept_id FROM Departments);

BSELECT name FROM Employees WHERE dept_id IN (SELECT dept_id FROM Departments);

CSELECT name FROM Employees WHERE dept_id IN SELECT dept_id FROM Departments;

DSELECT name FROM Employees WHERE dept_id IN (SELECT dept_name FROM Departments);

Step-by-Step Solution

Solution:

Step 1: Check syntax for IN with subquery
The subquery must be enclosed in parentheses.
Step 2: Validate correct comparison
The column compared must be compatible with the subquery's returned column.
Final Answer:
SELECT name FROM Employees WHERE dept_id IN (SELECT dept_id FROM Departments); -> Option B
Quick Check:
Subquery must be in parentheses and return single column [OK]

Quick Trick: Subquery with IN must be in parentheses [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is the correct way to write a subquery with the IN operator in SQL?