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 

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