Window functions were first introduced in MariaDB 10.2.0.
 
It is possible to use aggregate functions as window
functions. An aggregate function used as a window function
must have the OVER clause. For example, here's COUNT() used
as a window function:
 
select COUNT(*) over (order by column) from table;
 
MariaDB currently allows these aggregate functions to be
used as window functions: 
AVG
BIT_AND
BIT_OR
BIT_XOR
COUNT
MAX
MIN
STD
STDDEV
STDDEV_POP
STDDEV_SAMP
SUM
VAR_POP
VAR_SAMP
VARIANCE
 

 
 
 
 
 
 
 

URL:
https://mariadb.com/kb/en/library/aggregate-functions-as-window-functions/