Essential Books

Subquery in WHERE clause

suggest change

Use a subquery to filter the result set. For example this will return all employees with a salary equal to the highest paid employee. 

SELECT *
FROM Employees
WHERE Salary = (SELECT MAX(Salary) FROM Employees)
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