Mysql Cumulative Toplam Query

Merhaba

Mysql cumulative toplam alan örnek query aşağıdadır.

 

 

SET @csum := 0;
SELECT id, adet, (@csum := @csum + adet) AS cumulative_sum
FROM YourTable
ORDER BY id;

 

 

www.mysqlturkiye.com