SQL Query | How to calculate rolling / moving average ? | Ex - 3 day rolling average

[@jomeks5031]

Hi. What if i want to set to null the moving average with not enough rows... Like in your example the first two rows?

[@LearnatKnowstar]

This is a great question. Thank you for mentioning this scenario. You can use RowNumber function to calculate the Row Numbers and start the calculation only from the 3rd row. You can use CASE or IFF to perform this check - Please see example below - IIF(ROW_NUMBER() OVER(PARTITION BY FA.CurrencyKey ORDER BY DateKey)>=3,AVG(EndofDayRate) OVER (PARTITION BY FA.CurrencyKey ORDER BY DateKey ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) , NULL) AS _3DAYROLLINGAVG

[@terryh558]

Good job on your videos. I keep looking for more! As to the Moving Average of a Stock or Currency a) it should not start computing anything until you have number of days = moving average length, b) you do NOT want to fill in missing dates because (barring data errors) those are days when the market is closed like Sat/Sun/Holidays. Those days are just ignored. We could row_number the data, oldest data first, and use that to put NULL into the first 13 days if your MA length = 14. I seem to recall seeing a graphing feature in SSMS. If so, I'd like to see how to put this same data into a graph.

[@LearnatKnowstar]

Thank you for sharing this. These insights really help all of us learn and grow. 👍

[@payalia08]

Just got this task for my job thanks in advance😄

[@LearnatKnowstar]

Hope it helped

[@vpnath75]

Very informative! I would also be interested in seeing an explanation for the exponential moving average. Thanks!

[@LearnatKnowstar]

Thank you. We will posting the video in exponential rolling average soon 👍

[@aduvalasatheeshkumar4840]

Great Explanation...! Can you tell me a logic to get the previous row value if the curent row field is empty. Thanks ...!

[@LearnatKnowstar]

Thank you. You can get previous rows with lag function. If the row is entirely missing, you would first need to create a dummy record for the missing row.

[@samuelfsdev]

It's a greate content! These videos reawaken my interest in database management.

[@LearnatKnowstar]

Glad these are useful. Thanks 🙏

[@diydecor2653]

Simple and easy to understand

[@LearnatKnowstar]

Thank you 🙏

[@VinayKumar-lb3lq]

Hi, can u pls make videos on recursive querys from start to end.

[@LearnatKnowstar]

Yes sure. We are planning a series on SQL/DB concepts soon and these topics will be covered there. 👍

[@varshadeore154]

thanks.. very helpful

[@LearnatKnowstar]

Thank you

[@amukelaniebenezer406]

Thank you.

[@kristyowens2284]

Once again great explanation. Thanks!

[@LearnatKnowstar]

Thank you 🙏

[@mainlykanchan8740]

Ma'am will you please solve leetcode queries?

[@LearnatKnowstar]

Sure. We are planning soon 👍

[@nikolaybaranov2213]

Thanks, very helpful!

[@LearnatKnowstar]

Thank you 🙏