Description | The |
Syntax | LAST( |
Output | Varies based on input field type |
Variables
arg
: the field from which to fetch the last value.
Example
LAST(Value
) Over (Partition by Group
)
ID | Group | Value | LAST |
1 | A | 10 | 15 |
2 | A | 20 | 15 |
3 | A | 15 | NULL |
4 | B | 30 | 40 |
5 | B | 40 | NULL |