Window
Description
Window functions and operators perform calculations in a partitioned table.
The following window functions are available:
INDEX_ORDER indexes rows inside a partition based on the provided sorting.
INTERPOLATE interpolates missing values inside a partition with
CONSTANT
orLINEAR
slope.LEAD and LAG can be used to reference a following or previous row for every input row inside the partition.
RUNNING_SUM returns the sum of the previous rows inside the partition.
WINDOW_AVG calculates the average inside a user-defined sliding window.