[Solved] Identify the error in this query:SELECT name FROM Employees WHERE EXISTS SELECT 1 FROM Projects WHERE employee_id = Employees.id; | SQL

SQL - Subqueries

Identify the error in this query:

SELECT name FROM Employees WHERE EXISTS SELECT 1 FROM Projects WHERE employee_id = Employees.id;

AIncorrect table alias usage

BMissing parentheses around the subquery after EXISTS

CEXISTS cannot be used in SELECT clause

DMissing WHERE clause in subquery

Step-by-Step Solution

Solution:

Step 1: Check EXISTS syntax
The EXISTS operator 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 B
Quick Check:
EXISTS needs parentheses around subquery [OK]

Quick Trick: Always put subquery in parentheses 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: