ARRAY_MAX_GLOBAL
Returns the maximum element from all the array elements in each group.
Syntax
ARRAY_MAX_GLOBAL(<array>)
Parameters
| 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 |