This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.
ARRAY_MIN
Returns the minimum element in an array.
Syntax
ARRAY_MIN(<array>)
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<array> | The array or array-type column to be checked | ARRAY |
Return Type
NUMERIC
Example
The following examples calculates the minimum number in the levels array:
SELECT
ARRAY_MIN([ 1, 2, 3, 4 ]) AS levels;
Returns: 1