ARRAY_MIN - Firebolt Documentation

Data types
Information schema
Operators
SQL commands
SQL functions
- Overview
- Functions glossary
- Aggregation functions
- Array functions
- Binary functions
- Conditional and miscellaneous functions
- DataSketches functions
- Date and time functions
- Geospatial functions
- JSON functions
- Lambda functions
- Numeric functions
- Session functions
- String functions
- Table-valued functions
- Vector functions
- Window functions

On this page

Syntax
Parameters
Return Type
Example

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

Same as the element type of the array.

Example

The following example calculates the minimum number in the levels array:

SELECT
	ARRAY_MIN([ 1, 2, 3, 4 ]) AS levels;

Returns: 1

ARRAY_MAX ARRAY_REVERSE_SORT