SET @sum := 0;
SELECT *, (@sum := @sum + flow) AS cumulative_sum
FROM wrs_brwater_avg_gq WHERE mea_date > '2023-04-15'
ORDER BY mea_date;
mysql 查询数据 逐行累加
发布时间 2023-06-28 16:46:59作者: qwer78
SET @sum := 0;
SELECT *, (@sum := @sum + flow) AS cumulative_sum
FROM wrs_brwater_avg_gq WHERE mea_date > '2023-04-15'
ORDER BY mea_date;