JSON_MIN

The JSONMIN function returns the smallest in an array of numbers.

Syntax

JSON_MIN(json, jsonpath)

Example

The following example returns the smallest number in the array:

SELECT  JSON_MIN(JSON_ARRAY(1, 2, 3),'$') json

FROM /shared/examples/ds_orders/tutorial/customers

WHERE customerid = 10

Result: 1