Link Search Menu Expand Document

ARRAY_MAX

Returns the maximum element in an array <arr>.

Syntax 

ARRAY_MAX(<arr>)
Parameter Description
<arr> The array or array-type column to be checked

Example 

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

Returns: 4