Common Table Expressions (CTEs)

Snippet

Common Table Expressions (CTEs)

A CTE is a temporary result set that you can reference within another statement. It improves readability by breaking down complex queries into logical blocks.

snippet.sql
sql
WITH RegionSales AS (
  SELECT region, SUM(amount) AS total
  FROM sales
  GROUP BY region
)
SELECT *
FROM RegionSales
WHERE total > 1000;

Breakdown

WITH RegionSales AS (

Starts the CTE definition with a descriptive name.

SELECT region, SUM(amount) AS total FROM sales GROUP BY region

The internal query that generates the temporary result set.

SELECT * FROM RegionSales WHERE total > 1000;

The main query that uses the temporary result set defined above.

Previous snippet Next snippet

More Intermediate SQL exercises →

From your library

Common Table Expressions (CTEs)

Related