array_min function

Applies to: Databricks SQL Databricks Runtime

Returns the minimum value in array.

Syntax

array_min(array)

Arguments

• array: Any ARRAY with elements for which order is supported.

Returns

The result matches the type of the elements. NULL elements are skipped. If array is empty, or contains only NULL elements, NULL is returned.

Examples

> SELECT array_min(array(1, 20, NULL, 3));
 1

Related functions

• array_max function