Link Search Menu Expand Document

ARRAY_MAX_GLOBAL

Returns the maximum element from all the array elements in each group.

Syntax

ARRAY_MAX_GLOBAL(<array>)
Parameter Description Supported input types
<array> The array from which to return the maximum element. Any ARRAY type

Return Types

ARRAY

Example

The example below uses the following table Scores:

nickname recent_scores
steven70 [1,3,4]
sanderserin [3,5,6,7]
esimpson [30,50,60]

In this example, the function calculates the maximum score earned by each player’s recent scores. For example, the user esimpson received a maximum score of 60, so this value is returned in the max_score column.

SELECT
	nickname,
	ARRAY_MAX_GLOBAL(recent_scores) AS max_score
FROM
	Scores
GROUP BY
	nickname;

Returns:

nickname max_score
steven70 4
sanderserin 7
esimpson 60