Window Functions

SQL · Methods reference

📋 Overview

Analytics over a partition without collapsing rows — OVER (PARTITION BY … ORDER BY …).

Function	Description
`LAG(col, n)` / `LEAD(col, n)`	Previous / next row value
`FIRST_VALUE` / `LAST_VALUE` / `NTH_VALUE`	Window frame extremes
`SUM/AVG/COUNT(...) OVER (...)`	Running or partitioned aggregates
`FRAME` clauses	ROWS BETWEEN / RANGE BETWEEN bounds

See parent topic notes for runnable snippets; this page is the complete method index.

Mutating methods return None in Python — do not chain sort() / reverse() expecting a new list.
Default JS sort() compares strings — pass (a,b) => a-b for numbers.
SQL function names differ by dialect — verify Postgres vs MySQL docs.
Django QuerySet.update() skips save() signals and auto auto_now fields on models.