SQL · Functions and expressions

cte

A named temporary result set that makes complex queries readable.

sqlRunnable example sql course

Syntax

with name as (select …)

Example

Open in the lab

WITH totals AS (
  SELECT 'HTML' AS course, 30 AS minutes
)
SELECT course, minutes FROM totals;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.