How to Calculate Sum of Particular Column Based on Id in MySQL | Code Factory

MySQL Query :

select id, product_name as Product_Name, stock as Stock, sum(istock) as CF_Stock
from (
    select *
    from product_master t1,(
        select t.id as iid, t.stock as istock, t.product_name as product
        from product_master t
    ) t2
    where t1.id >= t2.iid
    order by t1.id,t1.product_name,t2.product
    ) t3
where product_name=product
group by id, product_name
order by product_name, id;


Output :

Tags :
find cumulative frequency of column
How to get cumulative sum
calculate cumulative frequency of column in mysql
how to calculate sum of particular column based on id in mysql