What does WITH (CTE) do?

Question

Accepted Answer

A CTE is syntactic sugar - the database runs the CTE's SELECT and lets you reference the result by name in the main query. CTEs do not persist after the query ends and they are not automatically cached. Their main benefit is readability: you can name an intermediate step instead of nesting subqueries three levels deep.