Subquery

Applies to: sql

A subquery is a query nested inside another, used as a value, a set for IN, or a derived table in FROM. A CTE (WITH) is often a clearer alternative for complex cases.

SELECT name FROM users
WHERE id IN (SELECT user_id FROM orders WHERE total > 100);

See also: select, cte, where