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