ARRAY_MAX

Returns the maximum element in an array.

Syntax

ARRAY_MAX(<array>)

Parameter	Description	Supported input types
`<array>`	The array or array-type column to be checked	`ARRAY`

Same as the element type of the array.

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

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

levels int null
4

Rows: 1Execution time: 5.14ms

⌘I