SQL Query | How to calculate YTD and MTD totals | Window Functions
HTML-код
- Опубликовано: 8 ноя 2020
- 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.com/company/know...
Email - learn@knowstar.org
![Sean Rii, Karyon, Sharzkii - Taungule [My Love] (Official Music Video)](http://i.ytimg.com/vi/eJoMuypbSzQ/mqdefault.jpg)
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
Very well explained the window frame options. Waiting for your next video!
Thank you
Awesome video! This is really helpful for me. Thanks a ton. Keep doing these type of videos more and more.!
Thank you
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 👍👍
Great way of explanation of whole concept, Thanks for this.
Thank you
Nicely explained. Keep up the good work
Thank you
you read my mind or sentiments lol, THANX!
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
Thank you so much! Great video!
Thank you
Very helpful video. Thank you 😃
Thank you
Solved my problem. Thanks a lot !!
Glad it helped!
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
What if we add SalesOrderNumber to order by, does that works the same as adding a ROWS BETWEEN?
Great video thanks!!!
Thank you
plz add query for previous year ytd in next column
YTD YTDprevious
what is the way to handle null values or missing months in windows function
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 ?
How to get the database for each and every query your sharing
🏆🥇
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 ?
Can you write a query of interest projection of daily amount deposit in account but amount is not equal daily
Nice one but plz share sql script to practice
@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.
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 about QTD?