[Solved] Identify the error in this query:SELECT emp_id FROM Employees WHERE dept_id IN SELECT dept_id FROM Departments; | SQL

SQL - Subqueries

Identify the error in this query:

SELECT emp_id FROM Employees WHERE dept_id IN SELECT dept_id FROM Departments;

ASubquery should be in the FROM clause.

BUsing IN instead of EXISTS.

Cdept_id should be compared with = not IN.

DMissing parentheses around the subquery after IN.

Step-by-Step Solution

Solution:

Step 1: Check IN operator syntax
The IN operator requires the subquery to be enclosed in parentheses.
Step 2: Identify missing parentheses
The query lacks parentheses around the subquery, causing a syntax error.
Final Answer:
Missing parentheses around the subquery after IN. -> Option D
Quick Check:
IN needs (subquery) [OK]

Quick Trick: Always put subquery inside parentheses after IN [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this query: