Glossary term
What is CTE (CTE (common table expression))?
CTE stands for CTE (common table expression).
A named temporary result defined with WITH, used to make a big query readable.
Learn it properly · SQL & PostgreSQLLesson 3: Subqueries, CTEs and Window FunctionsScalar, IN and EXISTS subqueries, WITH queries, a recursive category tree, ranking, LAG and LEAD, running totals and top-N per group.