Example (standard-style syntax). Verify supported keywords in your database.
WITH recent AS (SELECT id, total FROM orders WHERE created_at >= CURRENT_DATE - INTERVAL '30' DAY) SELECT * FROM recent;SQL WITH (CTE)
Define a common table expression for a single statement.
Syntax
WITH cte_name AS (SELECT ...) SELECT ... FROM cte_name;Examples
SQLite-oriented variant; dialect behaviour may differ.
WITH recent AS (SELECT id, total FROM orders WHERE created_at >= date('now', '-30 days')) SELECT * FROM recent;Parameters, options and clauses
| Option / clause | Description |
|---|---|
SELECT / expression | Choose output columns, expressions, aliases or functions. |
FROM / JOIN | Choose source tables and combine related rows. |
WHERE | Filter rows before grouping; use IS NULL for null checks. |
GROUP BY / HAVING | Group rows and filter aggregate groups. |
ORDER BY | Sort the result; ASC is commonly the default and DESC reverses it. |
LIMIT / OFFSET / FETCH | Limit or skip rows; syntax differs by database dialect. |
Dialect references
Review a command and its target before running it. Commands that alter files, services, accounts, disks, permissions or databases may be difficult to reverse. Test in a safe environment and keep backups.