[Solved] Which of the following is the correct syntax for a subquery in SQL? — Ans: SELECT name FROM employees WHERE id = (SELECT manager_id FROM departments WHERE... | SQL

SQL - Subqueries

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

ASELECT name FROM employees WHERE id IN SELECT manager_id FROM departments WHERE id = 5;

BSELECT name FROM employees WHERE id == (SELECT manager_id FROM departments WHERE id = 5);

CSELECT name FROM employees WHERE id = SELECT manager_id FROM departments WHERE id = 5;

DSELECT name FROM employees WHERE id = (SELECT manager_id FROM departments WHERE id = 5);

Step-by-Step Solution

Solution:

Step 1: Check correct subquery syntax
Subqueries must be enclosed in parentheses and use a single equals sign for comparison.
Step 2: Identify syntax errors in other options
SELECT name FROM employees WHERE id == (SELECT manager_id FROM departments WHERE id = 5); uses '==' which is invalid in SQL; C misses parentheses; D misses parentheses around subquery.
Final Answer:
SELECT name FROM employees WHERE id = (SELECT manager_id FROM departments WHERE id = 5); -> Option D
Quick Check:
Subqueries need parentheses and single '=' [OK]

Quick Trick: Subqueries always go inside parentheses with '=' or IN [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 subquery in SQL?