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

Publié le: 16 mars 2024
sur la chaîne: Ankit Bansal

17,822

543

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 Aggregations | SQL Adva...

Most Asked Join Based Interview Question:
   • Most Asked SQL JOIN based Interview Q...

Solving 4 Trick SQL problems:
   • Solving 4 Tricky SQL Problems

Data Analyst Spotify Case Study:
   • Data Analyst Spotify Case Study | SQL...

Top 10 SQL interview Questions:
   • Top 10 SQL interview Questions and An...

Interview Question based on FULL OUTER JOIN:
   • SQL Interview Question Based on Full ...

Playlist to master SQL :
   • Complex SQL Questions for Interview P...

Rank, Dense_Rank and Row_Number:
   • RANK, DENSE_RANK, ROW_NUMBER SQL Anal...

#sql #dataengineer

Sur cette page du site, vous pouvez voir la vidéo en ligne Rollup, Cube and Grouping Sets in SQL | Advanced SQL Tutorial | Beyond Group By durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Ankit Bansal 16 mars 2024, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 17,822 fois et il a aimé 543 téléspectateurs. Bon visionnage!

113,757

2.8K