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

Hello mam, 🤔🤔I having a doubt here !! you told that when calculating YTD / MTD we need to order it by unique column like (order_id), but it's important to clarify that using order_id for ordering within each year's partition may not guarantee the correct chronological order of orders within that year. If order_id is assigned arbitrarily or does not correspond to the actual date and time of the order, it can lead to inaccurate YTD calculations. so I think the best way is to order it by order_date instead of order_id. by the way your explanation is really outstanding 👍👍

Awesome video! This is really helpful for me. Thanks a ton. Keep doing these type of videos more and more.!

Great way of explanation of whole concept, Thanks for this.

Great explanation. I am using SAP HANA to achieve this, unfortunately, it doesn't allow ROWS or Range Function even though it allows lots of Window Function.

Very well explained the window frame options. Waiting for your next video!

This is superb... Easy to understand

Really good explanation!!!! I love this video

Great explanation

Thank you so much! Great video!

Nicely explained. Keep up the good work

Hey, Nice video One qsn, how do u decide/calculate current row in framing?

Solved my problem. Thanks a lot !!

Great video thanks!!!

Very helpful video. Thank you 😃

you read my mind or sentiments lol, THANX!

plz add query for previous year ytd in next column YTD YTDprevious

Nice one but plz share sql script to practice

Can you write a query of interest projection of daily amount deposit in account but amount is not equal daily

How to get the database for each and every query your sharing

What if we add SalesOrderNumber to order by, does that works the same as adding a ROWS BETWEEN?

what is the way to handle null values or missing months in windows function

@2:45 Order by is not mandatory if over clause is there. if order by is not there, we get total sum without any windowing.

Is not the Salesorder number different that has the same order date ? How is that duplicate .. what is the unique row definition there.. could you please elaborate ?

Hi Nice video Pls provide database for practice

I want to make balance as 0 if it ends in negative value, how can I do?? Pls reply

Can you pls help us to calculate year to month end ?

🏆🥇

What about QTD?