[Solved] Which of the following is the correct syntax for a nested subquery in SQL? — Ans: SELECT * FROM table WHERE id = (SELECT id FROM table2 WHERE value = 10); | SQL

SQL - Subqueries

Which of the following is the correct syntax for a nested subquery in SQL?

ASELECT * FROM table WHERE id IN SELECT id FROM table2 WHERE value = 10;

BSELECT * FROM table WHERE id == (SELECT id FROM table2 WHERE value = 10);

CSELECT * FROM table WHERE id = SELECT id FROM table2 WHERE value = 10;

DSELECT * FROM table WHERE id = (SELECT id FROM table2 WHERE value = 10);

Step-by-Step Solution

Solution:

Step 1: Review correct nested subquery syntax
The inner query must be enclosed in parentheses and used with operators like = or IN.
Step 2: Check each option
SELECT * FROM table WHERE id = (SELECT id FROM table2 WHERE value = 10); uses parentheses correctly and equals operator, making it valid SQL syntax.
Final Answer:
SELECT * FROM table WHERE id = (SELECT id FROM table2 WHERE value = 10); -> Option D
Quick Check:
Nested subquery syntax uses parentheses [OK]

Quick Trick: Always use parentheses around subqueries [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 is the correct syntax for a nested subquery in SQL?