WITH(CTE)
SafeCommon table expressions
WITH <cte> AS (SELECT ...) SELECT ... FROM <cte>;
Names subqueries for stepwise queries — flattens nesting; RECURSIVE walks hierarchies.
Examples
WITH big AS (SELECT user_id, SUM(total) s FROM orders GROUP BY user_id) SELECT * FROM big WHERE s > 100000;Aggregate, then filter, readably
Syntax
WITH name AS (SELECT ...) SELECT ... [WITH RECURSIVE ...]
Before you run it
Read only.
The same reference, with no signal at all
Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store