array_min function (Databricks SQL)

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