SQL Query | How to calculate Running Totals and Cumulative Sum ?

[@LearnatKnowstar]

Register at the below link to get US $100 off for Coursera Plus membership between Sep 8 - Sep 29, 2022. The Coursera Plus membership gets you access to unlimited courses and unlimited certifications! imp.i384100.net/Ke51on

[@james30321]

Ur method of teaching is good and easy to understand..

[@marczitelli2791]

Great video, was wondering if there is any way to do the same thing but using the LAG function? My first instinct was to try that, but I ended up getting incorrect values after the first summation. Thanks!

[@inhlam5909]

Select SUM(column value) OVER (PARTITION BY .. ORDER BY ..) From ..

[@akjay143]

If you add the 'rows unbounded preceding' after order by it will fix the running total issue. By default SQL take window range as 'range unbounded preceding' select *,sum(sal) over(order by job rows unbounded preceding) from emp (In my case 'job' column has duplicate records) You can test the below two query select *,sum(sal) over(order by job rows unbounded preceding) from emp select *,sum(sal) over(order by job range unbounded preceding) from emp

[@fahimkasmani1474]

precise and Accurate

[@LearnatKnowstar]

Thank you

[@hv0032113]

Great. Easy and simple.

[@LearnatKnowstar]

Thank you

[@liamgazz5985]

What SQL command do u use to calculate values in a specific 4 rows

[@LearnatKnowstar]

You can use where clause to filter the specific records first and then perform aggregations.

[@krishanukundu4089]

Thanks, you save me for good.

[@LearnatKnowstar]

Thank you

[@isalutefamille]

Does anyone know how can i handle running total when there is an opening balance?

[@explorer_baba2750]

How we can find running total without using any windows function. Anyone has any idea can share their thoughts.

[@tina8479]

Atleast give the reason of why the cumulative sum of marketing department did not change? why having duplicates is screwing up the sum?

[@syedozairsiraj6826]

because running total requires only unique values. if duplicate value is detected then will assume previous total only

[@yilu435]

???? 3900000 + 300000 = 4400000????

[@ankurgupta4502]

What it's doing is, it adds up the two duplicate records in this case 300000+200000 = 500000. Now that 4400000, is repeated on both duplicate records. The crux is duplicates will always have the same final result, which is made by the addition of their respective values.

[@explorer_baba2750]

How we can find running total without using any windows function. Anyone has any idea can share their thoughts.

[@chriskeo392]

Subqueries