Description | The |
Syntax | FILL( |
Output | Varies based on input field type |
Variables
arg: the field to get the maximum value of.
Example
MAX(Value) Over (Partition by Group)
ID | Group | Value | MAX |
1 | A | 10 | 20 |
2 | A | 20 | 20 |
3 | A | 15 | 20 |
4 | B | 30 | 40 |
5 | B | 40 | 40 |
Get the maximum value of a specified field within a range or partition
Updated over 2 weeks ago