[Solved] Which of the following shows the correct use of a subquery inside a WHERE clause? — Ans: SELECT * FROM orders WHERE customer_id IN (SELECT id FROM customers WHERE city... | SQL

SQL - Subqueries

Which of the following shows the correct use of a subquery inside a WHERE clause?

ASELECT * FROM orders WHERE customer_id = SELECT id FROM customers WHERE city = 'Chicago';

BSELECT * FROM orders WHERE (SELECT id FROM customers WHERE city = 'Chicago') = customer_id;

CSELECT * FROM orders WHERE customer_id IN (SELECT id FROM customers WHERE city = 'Chicago');

DSELECT * FROM orders WHERE customer_id IN SELECT id FROM customers WHERE city = 'Chicago';

Step-by-Step Solution

Solution:

Step 1: Identify correct subquery syntax
Subqueries in WHERE clauses must be enclosed in parentheses.
Step 2: Analyze options
SELECT * FROM orders WHERE customer_id IN (SELECT id FROM customers WHERE city = 'Chicago'); correctly uses IN with a subquery in parentheses.
Final Answer:
SELECT * FROM orders WHERE customer_id IN (SELECT id FROM customers WHERE city = 'Chicago'); is syntactically correct.
Quick Check:
Subqueries require parentheses in WHERE clauses [OK]

Quick Trick: Subqueries in WHERE need parentheses [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following shows the correct use of a subquery inside a WHERE clause?