JSON_MAX
The JSONMAX function returns the largest in an array of numbers.
Syntax
JSON_MAX(json, jsonpath)
Example
The following example returns the largest number in the array.
SELECT JSON_MAX(JSON_ARRAY(1, 2, 3),'$') json
FROM /shared/examples/ds_orders/tutorial/customers
WHERE customerid = 10
Result: 3