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