SUM JSONVALUE SQL

Viewed 27

In my SQL query I am selecting some data from my table :

SELECT data, 
        JSON_VALUE(payload, '$.period.from') as from_period, 
        JSON_VALUE(payload, '$.period.to') as to_period, 
        JSON_VALUE(payload, '$.quantity') as payload_quantity
FROM data
LEFT JOIN `table_name`

How can I get the SUM of JSON_VALUE(payload, '$.quantity') as payload_quantity?

0 Answers
Related