[Solved] Find the error in this SQL query:SELECT emp_name FROM Employees WHERE dept_id = (SELECT dept_id FROM Departments WHERE dept_name = 'Finance' OR); | SQL

SQL - Subqueries

Find the error in this SQL query:

SELECT emp_name FROM Employees WHERE dept_id = (SELECT dept_id FROM Departments WHERE dept_name = 'Finance' OR);

AThe subquery has a trailing OR without a condition.

BThe main query is missing a GROUP BY clause.

CThe subquery should use IN instead of =.

DThe table alias is missing in the subquery.

Step-by-Step Solution

Solution:

Step 1: Review the subquery syntax
The subquery ends with 'OR' but lacks a condition after it, causing a syntax error.
Step 2: Check other options
GROUP BY is not required here; '=' is valid if subquery returns one value; aliasing is optional.
Final Answer:
Option A -> Option A
Quick Check:
Trailing logical operators need conditions [OK]

Quick Trick: Logical operators must have conditions on both sides [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the error in this SQL query: