SQL Amazing Trick | Calculate Yearly, Quarterly, Monthly totals in a single SQL Query |Grouping Sets
HTML-код
- Опубликовано: 8 авг 2022
- In this tutorial, we learn to use Grouping Sets in SQL to calculate aggregations at different levels by taking the example -
How to calculate Yearly, Quarterly, Monthly totals in a single SQL Query?
All DDL and SQL statements can be found here-
know-star.blogspot.com/2022/0...
How to install SQL Server for practice?
• How to install SQL Ser...
Check out the complete list of SQL Query Interview Questions -
• SQL Query Interview Qu...
Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization
imp.i384100.net/qnXYk5
Beginners to Python Programming
skillshare.eqcm.net/GjMakm
Data Science and Business Analytics with Python
skillshare.eqcm.net/JrM1Aq
Get 40% OFF of Skillshare with code FLASH40 - October 2022
skillshare.eqcm.net/c/3299742...
Data Science Fundamentals with Python and SQL Specialization
imp.i384100.net/mgVYre
Python for Everybody Specialization
imp.i384100.net/DVz7Aj
Google Data Analytics Professional Certificate
imp.i384100.net/OR37oQ
Coursera Plus - Data Science Career Skills
imp.i384100.net/c/3299742/132...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Instagram - / learn.knowstar
Facebook - / knowstartrainings
Linkedin - www.linkedin.com/company/know...
Email - learn@knowstar.org
Another amazing topic. Thank you for posting relevant content.
Thank You.
Thanks for sharing
I learnt a new thing. Was not aware of Grouping Sets. Thank you for sharing.
Glad it was helpful!
Real life scenario examples. Thank you for the examples.
Thank you 🙏
Excellent! Thanks for sharing!! 😀
Glad it was helpful 🙏
Thank you. These topics are really helpful for us.
Glad to hear that
Good job! another good share! Thank you young lady for your hard work!👏👏👏
Thank you 🙏
Very well explained. Amazing tutorial series. Very helpful to build logic and frame SQL queries.
Thank you so much !
Your videos help me a lot to understand queries and and process of solving . Thank you so much 🙏🏿🙏🏿🙏🏿
Thank you 🙏
THANK you great explanation ,
I have a question ?can, add another column to this same table where every row is total month next to the accumulate column
Thank you for this video
Thank you!
This is really insightful thanks a lot
Thank you 🙏
Lovin it.
Thank you 🙏
Excellent example
Thank you 🙏
Can't we use datepart function for the same excercise?
Super..
Thank you 🙏
is datepart working for Weekly as well?
Very informative, expecting script for the practise
Hey there, here we meet again.
I have a general question as a new sql learner.
How to set up adventure works on sql sever?
Thanks for taking time for my enquiry.
God bless you.
Please find here the tutorial on installing SQL Server and Adventure Works DB.
ruclips.net/video/ncj0EDzy_rw/видео.html
Please give the datasets in description
Good example and great explanation.... Will this work in SQL server 2008 (Updates are in progress)
They should work. They were introduced as a new feature in SQL Server 2008.
is there a way to do the same thing in Sqlite ? Thank you
SQLLite has limited functions - so this might not work there. There are other similar functions - CUBE and ROLLUP. You might give those a try in SQLLite.
Need daily and monthly
I done know I get invalid month or year?
Please share the dataset link or file
Please find the link here -
know-star.blogspot.com/2022/08/sql-how-to-calculate-yearly-quarterly.html
Make understand us CTE Function in detail videos real time example
Sure. Will do 👍
@@LearnatKnowstar Thank you
Union is a expensive operation, not good approach