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
Put it to work
- Churn rate — Metric
- LTV — Metric
- Cohort retention dashboard — Dashboard
Self-service analytics for your team
Fast, flexible customer-facing analytics
Watch 5-minute demo
Also known as Common table expression
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.