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

SQL - Subqueries

Identify the error in this SQL query:

SELECT name FROM Employees WHERE dept_id = SELECT dept_id FROM Departments WHERE dept_name = 'HR';

AUsing = instead of IN for subquery

BMissing parentheses around the subquery

CWrong table name used in subquery

DSubquery returns multiple columns

Step-by-Step Solution

Solution:

Step 1: Check subquery syntax
The subquery must be enclosed in parentheses to be valid inside WHERE clause.
Step 2: Identify the missing parentheses
The query lacks parentheses around the subquery, causing syntax error.
Final Answer:
Missing parentheses around the subquery -> Option B
Quick Check:
Subqueries need parentheses [OK]

Quick Trick: Always wrap subqueries in parentheses [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: