[Solved] Find the error in this nested subquery:SELECT emp_id FROM Employees WHERE dept_id IN (SELECT dept_id FROM Departments WHERE name = 'Marketing' OR); | SQL

SQL - Subqueries

Find the error in this nested subquery:

SELECT emp_id FROM Employees WHERE dept_id IN (SELECT dept_id FROM Departments WHERE name = 'Marketing' OR);

AMissing closing parenthesis in subquery

BUsing IN instead of = for subquery

CSyntax error due to trailing OR in subquery

DIncorrect column name 'emp_id'

Step-by-Step Solution

Solution:

Step 1: Inspect subquery syntax
The subquery ends with 'OR' without a condition, causing syntax error.
Step 2: Confirm error type
Trailing logical operators without conditions are invalid in SQL.
Final Answer:
Syntax error due to trailing OR in subquery -> Option C
Quick Check:
Trailing OR causes syntax error [OK]

Quick Trick: Avoid dangling logical operators in queries [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 nested subquery: