[Solved] Identify the error in this query:SELECT * FROM Employees e WHERE EXISTS SELECT * FROM Salaries s WHERE s.emp_id = e.id; | SQL

SQL - Subqueries

Identify the error in this query:

SELECT * FROM Employees e WHERE EXISTS SELECT * FROM Salaries s WHERE s.emp_id = e.id;

AEXISTS cannot be used in WHERE clause.

BUsing SELECT * inside EXISTS is not allowed.

CMissing parentheses around the subquery after EXISTS.

DThe alias 'e' is not defined.

Step-by-Step Solution

Solution:

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

Quick Trick: Always put parentheses around subquery after EXISTS [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: