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

SQL - Subqueries

Identify the error in this SQL query:

SELECT emp_id FROM Employees WHERE dept_id IN SELECT dept_id FROM Departments WHERE dept_name = 'Finance';

AMissing parentheses around the subquery

BUsing IN instead of EXISTS

CIncorrect column name in WHERE clause

DUsing SELECT without FROM clause

Step-by-Step Solution

Solution:

Step 1: Check subquery syntax
The subquery must be enclosed in parentheses when used with IN.
Step 2: Identify error
The query lacks parentheses around the subquery after IN.
Final Answer:
Missing parentheses around the subquery -> Option A
Quick Check:
IN requires subquery in parentheses [OK]

Quick Trick: Always enclose subquery in parentheses with 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 SQL query: