ARRAY_MIN
Returns the minimum value of the given input array.
Syntax
ARRAY_MIN(X)
Arguments
X
Type: array
An array of any comparable value type.
Returns
Type: same as input
The minimum value of X.
Examples
| X | Output |
|---|---|
| [1,2,3,1,2,3] | 1 |
| [1,1,1,1,1,1,1] | 1 |
| [0,1,0,1,0,1] | 0 |
| [NULL,1,0,1,0,1] | NULL |
| [a,b,a,c,c,c] | a |
| [NULL] | NULL |
| [a,b,c,z] | a |
| [true, false] | false |