Aller au contenu principal

array_min function

Applies to: check marked yes Databricks SQL check marked yes 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​

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