Common table expression

Common table expression (CTE)

Definition:

• A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times.