MySQL HeatWave User Guide
This topic describes MySQL HeatWave window function support. For optimal performance, window functions in MySQL HeatWave utilize a massively parallel, partitioning-based algorithm. For general information about window functions, see Window Functions, in the MySQL Reference Manual.
MySQL HeatWave window function support includes support for:
WINDOW and OVER
clauses in conjunction with PARTITION BY,
ORDER BY, and WINDOW
frame specifications.
Nonaggregate window functions supported by MySQL Server, as described in Window Function Descriptions.
The following aggregate functions used as window functions:
Learn how to perform the following tasks: