Window Functions
A Window function in GitQL performs a calculation on a window (frame) of values and returns a single value
Name | Parameters | Return | Description |
---|---|---|---|
FIRST_VALUE | ANY | Any | Return first value in the window of values |
NTH_VALUE | ANY, INT | Any | Return n value in the window of values |
LAST_VALUE | ANY | Any | Return last value in the window of values |
ROW_NUMBER | INT | Return unique sequential integer to each row within the partition, starting from 1 |