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 on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).
Get it free on the App Store