Common Table Expressions (CTEs) in SQL

Common Table Expressions (CTEs) in SQL — a practical guide to SQL CTE WITH with clear examples you can reuse in real projects.

SQL Tutorial Series (58/100). Prefer one article? Read the complete SQL tutorial.

Short description

CTEs improve readability for multi-step queries.

CTE

WITH paid_orders AS (
  SELECT user_id, total FROM orders WHERE status = 'paid'
)
SELECT user_id, SUM(total) AS revenue
FROM paid_orders
GROUP BY user_id;