Glossary term
What is window function? Meaning for developers
A function that computes over a set of related rows without collapsing them, such as ROW_NUMBER or LAG.
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.