Window Functions

MariaDB starting with 10.2

Window functions were first introduced in MariaDB 10.2.0.

Note: The documentation is still in progress, and not all features have been added yet.

Window functions perform calculations across a set of rows related to the current row

2

Window Functions Overview
Window functions perform calculations across a set of rows related to the current row
CUME_DIST
Window function that returns the cumulative distribution of a given row
DENSE_RANK
Rank of a given row with identical values receiving the same result, no skipping
NTILE
Returns an integer indicating which group a given row falls into
PERCENT_RANK
Window function that returns the relative percent rank of a given row
RANK
Rank of a given row with identical values receiving the same result
ROW_NUMBER
Row number of a given row with identical values receiving a different result
1

Aggregate Functions as Window Functions
It is possible to use aggregate functions as window functions
1

Window Frames
Some window functions operate on window frames