SQL Amazing Trick | Calculate Yearly, Quarterly, Monthly totals in a single SQL Query |Grouping Sets

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.blog...
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.ne...
Beginners to Python Programming
skillshare.eqc...
Data Science and Business Analytics with Python
skillshare.eqc...
Get 40% OFF of Skillshare with code FLASH40 - October 2022
skillshare.eqc...
Data Science Fundamentals with Python and SQL Specialization
imp.i384100.ne...
Python for Everybody Specialization
imp.i384100.ne...
Google Data Analytics Professional Certificate
imp.i384100.ne...
Coursera Plus - Data Science Career Skills
imp.i384100.ne...
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.c...
Email - [e-mail]

[@kristyowens2284]

Another amazing topic. Thank you for posting relevant content.

[@LearnatKnowstar]

Thank You.

[@hv0032113]

I learnt a new thing. Was not aware of Grouping Sets. Thank you for sharing.

[@LearnatKnowstar]

Glad it was helpful!

[@diydecor2653]

Thank you. These topics are really helpful for us.

[@LearnatKnowstar]

Glad to hear that

[@rohanthakur6136]

Real life scenario examples. Thank you for the examples.

[@LearnatKnowstar]

Thank you 🙏

[@hasanmougharbel8030]

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.

[@LearnatKnowstar]

Please find here the tutorial on installing SQL Server and Adventure Works DB.
czcams.com/video/ncj0EDzy_rw/video.html

[@mainlykanchan8740]

Your videos help me a lot to understand queries and and process of solving . Thank you so much 🙏🏿🙏🏿🙏🏿

[@LearnatKnowstar]

Thank you 🙏

[@TheWANO327]

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

[@djjiang3718]

Good job! another good share! Thank you young lady for your hard work!👏👏👏

[@LearnatKnowstar]

Thank you 🙏

[@dimpyrathore818]

Very well explained. Amazing tutorial series. Very helpful to build logic and frame SQL queries.

[@LearnatKnowstar]

Thank you so much !

[@shekhark1139]

Very informative, expecting script for the practise

[@chintu2691994]

Good example and great explanation.... Will this work in SQL server 2008 (Updates are in progress)

[@LearnatKnowstar]

They should work. They were introduced as a new feature in SQL Server 2008.

[@saktipadamukherjee455]

Please give the datasets in description

[@dorayoung5149]

Thank you for this video

[@LearnatKnowstar]

Thank you!

[@amukelaniebenezer406]

Thanks for sharing

[@capitantomate6938]

Excellent! Thanks for sharing!! 😀

[@LearnatKnowstar]

Glad it was helpful 🙏

[@sankalpasarkar3540]

Excellent example

[@LearnatKnowstar]

Thank you 🙏

[@shreekantgosavi4726]

This is really insightful thanks a lot

[@LearnatKnowstar]

Thank you 🙏

[@TheVaibhavdang]

Can't we use datepart function for the same excercise?

[@erikaa2718]

is datepart working for Weekly as well?

[@vinodkumar-yz1bg]

Need daily and monthly

[@zeeshanazeem5212]

Lovin it.

[@LearnatKnowstar]

Thank you 🙏

[@rk-ej9ep]

Super..

[@LearnatKnowstar]

Thank you 🙏

[@ZeeNoorTrip]

I done know I get invalid month or year?

[@starkwedder9787]

is there a way to do the same thing in Sqlite ? Thank you

[@LearnatKnowstar]

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.

[@sagarmagdum7407]

Make understand us CTE Function in detail videos real time example

[@LearnatKnowstar]

Sure. Will do 👍

[@sagarmagdum7407]

@@LearnatKnowstar Thank you

[@TheVaibhavdang]

Please share the dataset link or file

[@LearnatKnowstar]

Please find the link here -
know-star.blogspot.com/2022/08/sql-how-to-calculate-yearly-quarterly.html

[@lax976]

Union is a expensive operation, not good approach