Window Function

Also known as · Window Functions

A calculation across a set of related rows that does not collapse them into one row, unlike GROUP BY.

When to use

Use it for ranking, running totals, and comparing with the previous or next row (LAG, LEAD). The window is defined with OVER. It needs MySQL 8.0 and cannot appear in WHERE.

See Read 01.

Appears in

No references yet.