[Solved] Which of the following SQL statements correctly uses a subquery in the FROM clause? — Ans: SELECT t.name FROM (SELECT name FROM employees) AS t; | SQL

SQL - Subqueries

Which of the following SQL statements correctly uses a subquery in the FROM clause?

ASELECT t.name FROM (SELECT name FROM employees) AS t;

BSELECT name FROM employees WHERE id IN (SELECT id FROM employees);

CSELECT name FROM employees JOIN (SELECT id FROM departments);

DSELECT name FROM employees FROM (SELECT id FROM departments);

Step-by-Step Solution

Solution:

Step 1: Identify correct subquery in FROM syntax
The subquery must be enclosed in parentheses and aliased.
Step 2: Analyze options
SELECT t.name FROM (SELECT name FROM employees) AS t; correctly uses a subquery in FROM with alias 't'. Options B and C use subqueries elsewhere or have syntax errors. SELECT name FROM employees FROM (SELECT id FROM departments); has invalid syntax.
Final Answer:
SELECT t.name FROM (SELECT name FROM employees) AS t; -> Option A
Quick Check:
Subquery in FROM requires alias and parentheses [OK]

Quick Trick: Subquery in FROM must have alias [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 SQL statements correctly uses a subquery in the FROM clause?