SQL Amazing Trick | Calculate Yearly, Quarterly, Monthly totals in a single SQL Query |Grouping Sets
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- 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 - learn@knowstar.org
Another amazing topic. Thank you for posting relevant content.
Thank You.
I learnt a new thing. Was not aware of Grouping Sets. Thank you for sharing.
Glad it was helpful!
Thank you. These topics are really helpful for us.
Glad to hear that
Real life scenario examples. Thank you for the examples.
Thank you 🙏
Your videos help me a lot to understand queries and and process of solving . Thank you so much 🙏🏿🙏🏿🙏🏿
Thank you 🙏
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.
th-cam.com/video/ncj0EDzy_rw/w-d-xo.html
Thank you for this video
Thank you!
Good job! another good share! Thank you young lady for your hard work!👏👏👏
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
Very well explained. Amazing tutorial series. Very helpful to build logic and frame SQL queries.
Thank you so much !
Excellent! Thanks for sharing!! 😀
Glad it was helpful 🙏
Excellent example
Thank you 🙏
Thanks for sharing
Please give the datasets in description
This is really insightful thanks a lot
Thank you 🙏
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.
Very informative, expecting script for the practise
Can't we use datepart function for the same excercise?
is datepart working for Weekly as well?
Need daily and monthly
Lovin it.
Thank you 🙏
Super..
Thank you 🙏
Make understand us CTE Function in detail videos real time example
Sure. Will do 👍
@@LearnatKnowstar Thank you
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.
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
I done know I get invalid month or year?
Union is a expensive operation, not good approach