[Solved] Identify the error in this query:SELECT * FROM orders WHERE customer_id = (SELECT customer_id FROM customers WHERE city = 'New York'); | SQL

SQL - Subqueries

Identify the error in this query:

SELECT * FROM orders WHERE customer_id = (SELECT customer_id FROM customers WHERE city = 'New York');

AIncorrect table name 'orders'

BMissing FROM clause in subquery

CSubquery returns multiple rows causing an error with '=' operator

DNo error, query is correct

Step-by-Step Solution

Solution:

Step 1: Analyze subquery result
The subquery selects customer_id from customers where city is 'New York'. This can return multiple customer IDs.
Step 2: Check operator compatibility
The main query uses '=' which expects a single value, but subquery returns multiple rows, causing an error.
Final Answer:
Subquery returns multiple rows causing an error with '=' operator -> Option C
Quick Check:
Use IN for multiple subquery results [OK]

Quick Trick: Use IN if subquery returns multiple values, not = [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: