Essential Books

Subquery in FROM clause

suggest change

A subquery in a FROM clause acts similarly to a temporary table that is generated during the execution of a query and lost afterwards. 

SELECT Managers.Id, Employees.Salary
FROM (
  SELECT Id
  FROM Employees
  WHERE ManagerId IS NULL
) AS Managers
JOIN Employees ON Managers.Id = Employees.Id
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Subqueries:
*Subqueries
*Subquery in FROM clause
*Subquery in WHERE clause
*Subquery in SELECT clause
*Correlated Subqueries
*Subqueries in FROM clause
*Filter query results using query on different table
*Subqueries in WHERE clause
*Subqueries in SELECT clause
Table Of Contents