4
Window Functions
Window functions perform calculations across a set of rows related to the current row.
-
Window Functions Overview
Window functions perform calculations across a set of rows related to the current row. -
AVG
Returns the average value. -
BIT_AND
Bitwise AND. -
BIT_OR
Bitwise OR. -
BIT_XOR
Bitwise XOR. -
COUNT
Returns count of non-null values. -
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. -
FIRST_VALUE
Returns the first result from an ordered set. -
JSON_ARRAYAGG
Returns a JSON array containing an element for each value in a given set of JSON or SQL values. -
JSON_OBJECTAGG
Returns a JSON object containing key-value pairs. -
LAG
Accesses data from a previous row in the same result set without the need for a self-join. -
LAST_VALUE
Returns the last value in a list or set of values. -
LEAD
Accesses data from a following row in the same result set without the need for a self-join. -
MAX
Returns the maximum value. -
MEDIAN
Window function that returns the median value of a range of values. -
MIN
Returns the minimum value. -
NTH_VALUE
Returns the value evaluated at the specified row number of the window frame. -
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. -
PERCENTILE_CONT
Continuous percentile. -
PERCENTILE_DISC
Discrete percentile. -
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. -
STD
Population standard deviation. -
STDDEV
Population standard deviation. -
STDDEV_POP
Returns the population standard deviation. -
STDDEV_SAMP
Standard deviation. -
SUM
Sum total. -
VAR_POP
Population standard variance. -
VAR_SAMP
Returns the sample variance. -
VARIANCE
Population standard variance. -
Aggregate Functions as Window Functions
It is possible to use aggregate functions as window functions. -
ColumnStore Window Functions
Summary of window function use with the ColumnStore engine -
Window Frames
Some window functions operate on window frames.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
