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