Rollup, Cube and Grouping Sets in SQL | Advanced SQL Tutorial | Beyond Group By

In this video we will understand what are Rollup, Cube and Grouping Sets in SQL. Why we need it in a very simple way.
script:
Create table orders
(
Id int primary key identity,
Continent nvarchar(50),
Country nvarchar(50),
City nvarchar(50),
amount int
);
Insert into orders values('Asia','India','Bangalore',1000)
Insert into orders values('Asia','India','Chennai',2000)
Insert into orders values('Asia','Japan','Tokyo',4000)
Insert into orders values('Asia','Japan','Hiroshima',5000)
Insert into orders values('Europe','United Kingdom','London',1000)
Insert into orders values('Europe','United Kingdom','Manchester',2000)
Insert into orders values('Europe','France','Paris',4000)
Insert into orders values('Europe','France','Cannes',5000)
;
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregat...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN ba...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL P...
Data Analyst Spotify Case Study:
• Data Analyst Spotify C...
Top 10 SQL interview Questions:
• Top 10 SQL interview Q...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question...
Playlist to master SQL :
• Complex SQL Questions ...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_...
#sql #dataengineer

[@ankitbansal6]

Is sound quality better? I am using a mic for the first time :)

[@sathwikdhanya5400]

Yes, we could also hear mixer in background

[@hritikapal683]

Perfect it is

[@atikhsohail3461]

Yes perfect

[@rajatmaurya6401]

Crystal clear. 😉

[@hamidabano2075]

You don't need mic Ankit. The content is anyways top notch to keep us waiting for the videos and watch them , ending up learning something new and important to impress the interviewers 😅

[@nipunshetty9640]

Your explaination is the best I seen till date from schooling to now, best teacher ever Sir hatsoff

[@dasoumya]

Great explanation Ankit!
I swear nobody in this RUclips platform can explain like you did....your RUclips channel made me kind of pro in SQL.

[@LachlanNoone]

Brilliant video! So clear. I struggled to grasp these concepts with both my uni lectures and the prescribed textbook. Will definitely be returning for more of your content.

[@ankitbansal6]

Glad it was helpful!

[@rosieshiels7500]

Such an excellent video Ankit! Keep up the great work!

[@srinubathina7191]

Your way of explanation is next level Bro
Thank you so much

[@ankitbansal6]

You are most welcome

[@raviagrawal2862]

Superb explanation

[@subhajitdey6806]

Ankit these are the contents i have ben waiting for , this is top notch , need more content on advance SQL and data engineering

[@dfkgjdflkg]

As usual great content. One should only learn what you do, and One will be as great as you are

[@sanketannadate4407]

Really brilliant all key points where addressed

[@kaamgaming6124]

nice really helpful

[@zainaltaf4935]

Yup it clear all my concepts regarding roll up

[@Vonneuman8676]

Thanks for such beautiful videos. Always grateful to you

[@ankitbansal6]

My pleasure 😊

[@Hkumar_new]

Really great

[@ayushi_patra]

This is beautiful Ankit! Thank you for sharing! I have request, could you please make a video on how to find a grain in any given fact table? Specially sometimes when we are not equipped with business knowledge, how do we find the grain in an unknown fact table? It will be very valuable. Thanks in advance!

[@ankitbansal6]

Sure

[@devendrabarasker4987]

Thanks sir for teaching this kind of concepts 🎉

[@ramakumarguntamadugu1299]

very good explanation.. keep posting an amazing content 👌👌🎉🎉

[@ankitbansal6]

Thanks a lot 😊

[@sakinasaifee3118]

Awesome content!

[@sarvesh714]

Hi Ankit, thx for posting these videos, your content is great. Can you plz make videos on advanced concepts like materialized views and indexing?

[@ankitbansal6]

Yes, sure

[@JatinC_Official]

Amazing ❤

[@basireddymadhusudhanreddy7990]

clear explanatation

[@saiswaroop3570]

Clear explanation

[@santoshkiran5858]

Brilliant 👍

[@sagargudla1362]

thanks for this scenario 😊

[@pateldh23]

Voices is best 👌

[@yashshrivastava280]

nice

[@gazart8557]

❤❤very good sir!! Please also upload the insert script for the pervious video on business intelligence where tou show ytd etc

[@ankitbansal6]

Uploaded . Check description

[@raagpathy]

Yes it is better
Bohot mast

[@ankitbansal6]

Thank you 😊

[@vinayanayak1228]

you are awesome !

[@soumyabiswal6324]

just a question sir... are all these topics covered under your SQL zero to hero course ?

[@ankitbansal6]

Covered here in this video 😊

[@OneNI83]

quick Q),what type of syntax that you used in 2:37 (select null country,null city etc..) This is the first time i saw a syntax like this .Can you please further explain on this.

[@ankitbansal6]

Just hard coding null value to columns..like.null as country

[@nikhilpatil9582]

Hello Ankit,
I want to enroll for the recorded session course of SQL. Can you please share the link of the same..

[@ankitbansal6]

www.namastesql.com/courses/SQL-For-Analytics-6301f405e4b0238f71788354

[@sureshraina321]

will this feature available across all the databases ?
or restricted to SQL SERVER ?

[@ankitbansal6]

Mostly all

[@ashutoshkumar5721]

are these commands supported in MySQL??

[@ankitbansal6]

Mostly yes

[@guyzterrorguyz1]

Please tell me what all RDBMS supports these functions. I am interested in Oracle and SQL server

[@ashishyadav-mf4hp]

00:00 - Rollup
05:30 - Cube
07:16 - Grouping Sets

[@ajay_jangra]

nice