Data and Business Intelligence Glossary Terms

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
V
W
X

CTE

Also known as

Common table expression

What is a CTE?

A common table expression, or CTE, is a named result set in a SQL query, equivalent to a subquery. CTEs are evaluated each time the main query is run.

Key article

Thanks for your feedback!