MariaDB starting with 10.2

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:


Comments loading...