Common Table Expressions

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 ...