SQL Query | How to calculate YTD and MTD totals | Window Functions
Vložit
- čas přidán 11. 09. 2024
- This video discusses the SQL Query to calculate the YTD and MTD Totals.
It also discusses the importance of window framing in SQL.
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - learn@knowstar.org
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.!
Thank you
Very well explained the window frame options. Waiting for your next video!
Thank you
Great way of explanation of whole concept, Thanks for this.
Thank you
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.
Hello Arpit. Could you please suggest in HANA how to calucalte total sales of material for every month in that year for the last 12 months
. Which function we are going to use in window function to acheive it . Kindly suggest. Thank you.
This is superb... Easy to understand
Thank you
Really good explanation!!!! I love this video
Thank you
Nicely explained. Keep up the good work
Thank you
Hey, Nice video
One qsn, how do u decide/calculate current row in framing?
The current row is the row being processed by the database
Great explanation
Thank you
Thank you so much! Great video!
Thank you
you read my mind or sentiments lol, THANX!
Solved my problem. Thanks a lot !!
Glad it helped!
Great video thanks!!!
Thank you
Very helpful video. Thank you 😃
Thank you
plz add query for previous year ytd in next column
YTD YTDprevious
Nice one but plz share sql script to practice
How to get the database for each and every query your sharing
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
You can install AdventureWorks database form Microsoft for practice.
Hi u can teach ssis and cloud computing...I want learn
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
Can you write a query of interest projection of daily amount deposit in account but amount is not equal daily
I want to make balance as 0 if it ends in negative value, how can I do?? Pls reply
🏆🥇
@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.
Can you pls help us to calculate year to month end ?
What about QTD?