JSON_SUM

The JSONSUM function returns the sum of the elements in the JSON array.

Syntax

JSON_SUM(json, jsonpath)

Example

The following example calculates the sum of the elements in the JSON array:

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

FROM /shared/examples/ds_orders/tutorial/customers

WHERE customerid = 10

Result: 6