Working with Rollups and Cubes in PostgreSQL | SQL Basics

  Рет қаралды 68,789

Job Ready Programmer

Job Ready Programmer

Күн бұрын

Пікірлер: 75
@MonteFisto100
@MonteFisto100 2 жыл бұрын
Finally understood it, there's so many bad and overcomplicated explainations out there, but this one is really damn good. Thank you.
@nupurgautam1
@nupurgautam1 4 жыл бұрын
Thanks for sharing this video, it's just the amount of details I needed. Not sure who gave those 3 dislikes, ignore them...
@akwamfoneventus6124
@akwamfoneventus6124 8 ай бұрын
This explained it a lot better than my course videos -- some people just teach better without efforts. thank you
@matteomarinelli3752
@matteomarinelli3752 4 жыл бұрын
Thank you very much! You were the only one I was able to fully understand, you saved my day ahahah :)
@aqsachappalwala4363
@aqsachappalwala4363 Жыл бұрын
best explanation ever .Thank you
@acleahcim
@acleahcim 9 ай бұрын
Amazing video. Helped me with one of my assignments. Thank you for creating an easy to understand video with real examples.
@adamsleuis7794
@adamsleuis7794 Жыл бұрын
Man, I love your explanation. You deserve a 👍
@fatenaljabaly3911
@fatenaljabaly3911 2 жыл бұрын
Thank you so much! You really helped me understand the difference between the two.
@СофьяТретьякова-я4ц
@СофьяТретьякова-я4ц 2 жыл бұрын
Thanks a lot! I didnt find appropriate information on russian resourses and decided to visit your channel. This video make cube, rollup and groupping sets more clear for me. So keep on
@afsananasrin4700
@afsananasrin4700 4 ай бұрын
Perfectly explained. Thanks for making me understand the concepts clearly.
@Jobreadyprogrammer
@Jobreadyprogrammer 3 ай бұрын
Great to hear!
@nalinikantadash8669
@nalinikantadash8669 2 ай бұрын
Great explanation.Thanks a lot.
@kiararicketts2971
@kiararicketts2971 5 ай бұрын
Great and simple explanation, thank you!!
@Jobreadyprogrammer
@Jobreadyprogrammer 3 ай бұрын
Welcome!
@Advanced_Learner
@Advanced_Learner 7 ай бұрын
many thanks for making it so simple to understand
@ukaszkiepas57
@ukaszkiepas57 2 жыл бұрын
AWESOME !!! FINALLY UNDERSTOOD :)
@angelopaligutan1665
@angelopaligutan1665 3 жыл бұрын
Thank you for a concise yet knowledge-packed video! It helped me a lot
@ranjithparuchuri6463
@ranjithparuchuri6463 2 жыл бұрын
thanks for making this video of rollup and cude.
@hiraethneko
@hiraethneko Жыл бұрын
Thanks so much for this!
@sravanialluri5756
@sravanialluri5756 9 ай бұрын
Best Explanation, Thank you so much
@samyboulos4642
@samyboulos4642 2 жыл бұрын
I love the way you explained it.
@kamilyaka3406
@kamilyaka3406 Жыл бұрын
Very good explanation, thank you.
@kelvinojeda8222
@kelvinojeda8222 Жыл бұрын
Excellent video.
@mahdihabibi1875
@mahdihabibi1875 2 жыл бұрын
Great video. Thanks man 🙏
@lenaso4555
@lenaso4555 2 жыл бұрын
Thank you very much for explaining the topic so easily!!
@hydronicrocker
@hydronicrocker 6 жыл бұрын
With GROUP BY GROUPING SETS, why does the () value at the end show first in the output when its the last item in the query?
@satyendrasingh3805
@satyendrasingh3805 3 жыл бұрын
one video cleared all the questions that I had in my mind, Great work!
@paulfunigga
@paulfunigga 5 ай бұрын
Bro, this is very good, thank you for enlightening me!
@Jobreadyprogrammer
@Jobreadyprogrammer 3 ай бұрын
My pleasure!
@alexbarasa3816
@alexbarasa3816 3 жыл бұрын
excellent explanation sir. THank you so much for this. Straightforward and educative.
@mossen6225
@mossen6225 Жыл бұрын
If this can make someones life easy 😃 CREATE TABLE sales ( continent varchar(20), country varchar(20), city varchar(20), units_sold integer ); Insert INTO sales VALUES ('North America', 'Canada', 'Toronto', 10000); Insert INTO sales VALUES ('North America', 'Canada', 'Montreal', 5000); Insert INTO sales VALUES ('North America', 'Canada', 'Vancouver', 15000); Insert INTO sales VALUES ('Asia', 'China', 'Hong Kong', 7000); Insert INTO sales VALUES ('Asia', 'China', 'Shanghai', 3000); Insert INTO sales VALUES ('Asia', 'China', 'Tokyo', 5000); Insert INTO sales VALUES ('Europ', 'UK', 'London', 6000); Insert INTO sales VALUES ('Europ', 'UK', 'Manchester', 12000); Insert INTO sales VALUES ('Europ', 'France', 'Paris', 5000); select * from sales;
@degenaratezan2358
@degenaratezan2358 2 ай бұрын
thank you very much man
@Doshvari
@Doshvari 4 жыл бұрын
Thank you , that was very good
@iaroslavd.916
@iaroslavd.916 5 ай бұрын
Nicely explained, very clear😊
@Jobreadyprogrammer
@Jobreadyprogrammer 3 ай бұрын
Thank you 🙂
@PunjabiKush
@PunjabiKush 3 жыл бұрын
Thanks a lot man. You taught me more then my teacher did in this video. She skimmed over this subject within 3-5 mins at the end of class and I know this will be on the midterm. I find it very stupid for someone to teach us but not teach us if you get what I mean. Nonetheless I'm studying up and hoping I will pass the test with an above than average grade. Thanks.
@jaybee2402
@jaybee2402 2 жыл бұрын
She possibly taught you a far bigger lesson - women aren't excited by technology, mechanics etc, and therefore don't understand them.
@Pichler96
@Pichler96 11 ай бұрын
very helpful! Thank you :)
@demetridoes
@demetridoes 3 жыл бұрын
Amazing video! So much better than my university lecturer. Made so simple to understand
@schaumaul
@schaumaul 4 жыл бұрын
this guy is a legend
@joelcampos3073
@joelcampos3073 Жыл бұрын
Very interesting and very well explained!!!
@IdleKeeper
@IdleKeeper Жыл бұрын
Well explained thank you very much, really appreciate it!
@Davlet
@Davlet Жыл бұрын
at last someone explained it clearly)
@NirajPRoxx
@NirajPRoxx 6 жыл бұрын
Thank you so much, that was very detailed explanation. Got very confused when my teacher explained it.
@nv9946
@nv9946 4 жыл бұрын
Thanks for sharing this video. Very well explained.
@estleexin7584
@estleexin7584 Жыл бұрын
very nice explaination
@karimchennoufi698
@karimchennoufi698 3 жыл бұрын
thnx for sharing this good video !! it helps a lot for my exam preparation
@buuqmarabo2778
@buuqmarabo2778 6 жыл бұрын
u taught me a lot through all your vids, thank!
@dorcasogute4192
@dorcasogute4192 5 жыл бұрын
Very effective!!!
@ngocmainguyen521
@ngocmainguyen521 3 жыл бұрын
Thank you so much!
@ramnaresh4582
@ramnaresh4582 6 жыл бұрын
Really very awesome and useful to me . Thank you.
@aarontan5748
@aarontan5748 2 жыл бұрын
Thank you!
@bayerok1582
@bayerok1582 3 жыл бұрын
Thank you so much!!!
@MithileshParkhad
@MithileshParkhad Жыл бұрын
Cube function is not available in google bigquery. is their any other alternative ?
@suhas3785
@suhas3785 3 жыл бұрын
Thanks God bless you.....
@oliviermesseumeni9623
@oliviermesseumeni9623 4 жыл бұрын
You are the best thank you so much sir!
@angmathew4377
@angmathew4377 3 жыл бұрын
how do we know how many rows we will get from group by cube?
@hoangphucle9347
@hoangphucle9347 3 жыл бұрын
very useful. tks a lot
@saki23_220
@saki23_220 6 ай бұрын
Perfect
@twinklegarg1413
@twinklegarg1413 3 жыл бұрын
Sir group by ek se jyada columns ke base pe perform to skit hai
@jordan142495
@jordan142495 3 жыл бұрын
Thanks 😀
@Citrinestones
@Citrinestones 8 ай бұрын
LIFESAVER!!!
@oceanheadted
@oceanheadted 4 жыл бұрын
Does it work when there is no hierarchy between the dimension column? E.g. if you were analysing shoe sales data, by size, colour and style...
@pankajkharade6936
@pankajkharade6936 3 жыл бұрын
Excellent
@saikatde6343
@saikatde6343 2 жыл бұрын
This is awesome. :)
@akrammezrag4394
@akrammezrag4394 3 жыл бұрын
thanks bro.
@mozzjonas9292
@mozzjonas9292 3 жыл бұрын
Where is link for script
@mohaiminulhasan252
@mohaiminulhasan252 3 жыл бұрын
People like you turn into Data Engineers, and people who can't get that job are assigned to teach students like me. There has to be a fix for this.
@faranakyakhdani185
@faranakyakhdani185 2 жыл бұрын
amazing
@vedant_10-09
@vedant_10-09 Жыл бұрын
#1064 limit 0,25 error @groupby grouping sets
@montaserfadel7327
@montaserfadel7327 Жыл бұрын
impressiv
@medjl6083
@medjl6083 3 жыл бұрын
what is this the name of software.
@omkarpatil9886
@omkarpatil9886 3 жыл бұрын
Postgrass sql
@nileshthorat2403
@nileshthorat2403 3 жыл бұрын
Present sir
@meriemtrabelsi5517
@meriemtrabelsi5517 2 жыл бұрын
SubTotals with SQL using ROLLUP
7:06
James Oliver
Рет қаралды 10 М.
What is a Database?
10:04
Job Ready Programmer
Рет қаралды 468
Who's spending her birthday with Harley Quinn on halloween?#Harley Quinn #joker
01:00
Harley Quinn with the Joker
Рет қаралды 26 МЛН
When Cucumbers Meet PVC Pipe The Results Are Wild! 🤭
00:44
Crafty Buddy
Рет қаралды 41 МЛН
Увеличили моцареллу для @Lorenzo.bagnati
00:48
Кушать Хочу
Рет қаралды 7 МЛН
Amazing remote control#devil  #lilith #funny #shorts
00:30
Devil Lilith
Рет қаралды 15 МЛН
ROLLUP & CUBE in SQL | Oracle SQL Tutorial Videos | Mr.Vijay Kumar
17:23
Naresh i Technologies
Рет қаралды 48 М.
Business Intelligence: Multidimensional Analysis
24:15
Michael Lamont
Рет қаралды 146 М.
Excel Expert Lesson 6-3: Understand OLAP, MDX and Business Intelligence.
10:18
How I use SQL as a Data Analyst
15:30
Luke Barousse
Рет қаралды 842 М.
6 SQL Joins you MUST know! (Animated + Practice)
9:47
Anton Putra
Рет қаралды 196 М.
SQL Window Functions in 10 Minutes
10:13
Colt Steele
Рет қаралды 86 М.
SELECT Clause in SQL (Oracle SQL Certification) (Lesson 4)
15:50
Job Ready Programmer
Рет қаралды 25 М.
Difference between cube and rollup in SQL Server
5:38
kudvenkat
Рет қаралды 87 М.
Who's spending her birthday with Harley Quinn on halloween?#Harley Quinn #joker
01:00
Harley Quinn with the Joker
Рет қаралды 26 МЛН