ARRAY_MAX
All functions > ARRAY > ARRAY_MAX
Returns the largest value in an array using natural ordering.
Signatures
Returns: The largest value in the array, or NULL for empty arrays
ARRAY_MAX(array: ARRAY<T>) → Tsql
| Parameter | Type | Required | Description |
|---|---|---|---|
array | ARRAY<T> | Yes | The array to find the maximum value from |
Notes
- Returns the maximum element using natural ordering
- Ignores NULL values when determining the maximum
- Returns NULL if array is empty or contains only NULL values
- Works with numbers, strings, dates, or any comparable type
- Uses lexicographic ordering for strings
On this page