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