SQL Tips and Tricks - 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: https://youtu.be/5Ighj_2PGV0 Most Asked Join Based Interview Question: https://youtu.be/xR87ctOgpAE Solving 4 Trick SQL problems: https://youtu.be/Ck1gQrlS5pQ Data Analyst Spotify Case Study: https://youtu.be/-YdAIMjHZrM Top 10 SQL interview Questions: https://youtu.be/Iv9qBz-cyVA Interview Question based on FULL OUTER JOIN: https://youtu.be/KQfWd6V3IB8 Playlist to master SQL : https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb Rank, Dense_Rank and Row_Number: https://youtu.be/xMWEVFC4FOk #sql #dataengineer