假设有这样一组数据,要求计算出amount字段减去extend字段(json类型)里面的refund_amount值的总和
SELECT ROUND(SUM(amount-(IFNULL(extend->'$.refund_amount',0))),2) FROM orders_goods
假设有这样一组数据,要求计算出amount字段减去extend字段(json类型)里面的refund_amount值的总和
SELECT ROUND(SUM(amount-(IFNULL(extend->'$.refund_amount',0))),2) FROM orders_goods