TA貢獻(xiàn)1804條經(jīng)驗(yàn) 獲得超2個(gè)贊
set @csum := 0;update YourTableset cumulative_sum = (@csum := @csum + count)order by id;
cumulative_sum
set @csum := 0;select id, count, (@csum := @csum + count) as cumulative_sumfrom YourTableorder by id;
TA貢獻(xiàn)1794條經(jīng)驗(yàn) 獲得超8個(gè)贊
SELECT t.id, t.count, (SELECT SUM(x.count) FROM TABLE x WHERE x.id <= t.id) AS cumulative_sum FROM TABLE tORDER BY t.id
SELECT t.id, t.count, @running_total := @running_total + t.count AS cumulative_sum FROM TABLE t JOIN (SELECT @running_total : = 0) rORDER BY t.id
JOIN (SELECT @running_total := 0) r
SET
r
ORDER BY
TA貢獻(xiàn)1845條經(jīng)驗(yàn) 獲得超8個(gè)贊
SUM(col) OVER():
SELECT *, SUM(cnt) OVER(ORDER BY id) AS cumulative_sumFROM tab;
┌─────┬──────┬────────────────┐
│ id │ cnt │ cumulative_sum │
├─────┼──────┼────────────────┤
│ 1 │ 100 │ 100 │
│ 2 │ 50 │ 150 │
│ 3 │ 10 │ 160 │
└─────┴──────┴────────────────┘
舉報(bào)