Subquery

Use a query inside another query

Advanced

SQL

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

What each clause does

The subquery (SELECT user_id FROM orders WHERE total > 100) runs first. IN checks if id matches any value in that result set.

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

SELECT All Rows SELECT with WHERE INSERT INTO UPDATE SET DELETE FROM INNER JOIN LEFT JOIN GROUP BY ORDER BY CREATE TABLE Common Table Expression (CTE)Window Function UPSERT (ON CONFLICT)LIMIT & OFFSET