Description | The |
Syntax | MIN( |
Output | Varies based on input field type |
Variables
arg
: the field to return the minimum value from.
Example
MIN(Value
) Over (Partition by Group
)
ID | Group | Value | MIN |
1 | A | 10 | 10 |
2 | A | 20 | 10 |
3 | A | 15 | 10 |
4 | B | 30 | 30 |
5 | B | 40 | 30 |
Get the minimum value of a specified field within a range or partition
Description | The |
Syntax | MIN( |
Output | Varies based on input field type |
arg
: the field to return the minimum value from.
MIN(Value
) Over (Partition by Group
)
ID | Group | Value | MIN |
1 | A | 10 | 10 |
2 | A | 20 | 10 |
3 | A | 15 | 10 |
4 | B | 30 | 30 |
5 | B | 40 | 30 |