Common Table Expression (CTE)

WITH active_users AS (
  SELECT * FROM users WHERE active = true
)
SELECT name, email FROM active_users WHERE age > 25;

What each clause does

WITH creates a named temporary result set (active_users). The main query can reference it like a table.

Related tools

Other SQL examples