Working with Rollups and Cubes in PostgreSQL | SQL Basics
HTML-код
- Опубликовано: 27 мар 2018
- This video is from the course "Master SQL for Data Science"
➡️ Learn MORE:
- Access all of my software development courses using the discount below: www.jobreadyprogrammer.com/p/...
- Email me if you have questions: info@jobreadyprogrammer.com
- Become Job Ready with our NEW Programming Guide (PDF): pages.jobreadyprogrammer.com/...
=========================================
➡️ Job Ready Programmer Socials:
linktr.ee/jobreadyprogrammer
=========================================
#jobreadyprogrammer #databasedeveloper #softwaredeveloper #career #sql #tableau #databases #database #webdeveloper #html #css #javascript #java #javabasics #javatutorial #javaprogramming #aws #admin #jobready #programmer
Finally understood it, there's so many bad and overcomplicated explainations out there, but this one is really damn good. Thank you.
Thanks for sharing this video, it's just the amount of details I needed. Not sure who gave those 3 dislikes, ignore them...
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
Thank you very much!
You were the only one I was able to fully understand, you saved my day ahahah :)
Thank you for a concise yet knowledge-packed video! It helped me a lot
Thank you so much!
You really helped me understand the difference between the two.
one video cleared all the questions that I had in my mind, Great work!
Thank you very much for explaining the topic so easily!!
I love the way you explained it.
Man, I love your explanation. You deserve a 👍
u taught me a lot through all your vids, thank!
Amazing video! So much better than my university lecturer. Made so simple to understand
many thanks for making it so simple to understand
Well explained thank you very much, really appreciate it!
Thanks so much for this!
Amazing video. Helped me with one of my assignments. Thank you for creating an easy to understand video with real examples.
AWESOME !!!
FINALLY UNDERSTOOD :)
thanks for making this video of rollup and cude.
Best Explanation, Thank you so much
Really very awesome and useful to me . Thank you.
Very interesting and very well explained!!!
Thank you so much, that was very detailed explanation. Got very confused when my teacher explained it.
Great video. Thanks man 🙏
This explained it a lot better than my course videos -- some people just teach better without efforts. thank you
very helpful! Thank you :)
Thank you , that was very good
best explanation ever .Thank you
excellent explanation sir. THank you so much for this. Straightforward and educative.
Very good explanation, thank you.
Thanks for sharing this video. Very well explained.
Thank you so much!
You are the best thank you so much sir!
Excellent video.
thnx for sharing this good video !! it helps a lot for my exam preparation
Very effective!!!
Thank you!
Perfectly explained. Thanks for making me understand the concepts clearly.
Great to hear!
very useful. tks a lot
very nice explaination
this guy is a legend
Nicely explained
This is awesome. :)
Great and simple explanation, thank you!!
Welcome!
Thanks God bless you.....
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.
She possibly taught you a far bigger lesson - women aren't excited by technology, mechanics etc, and therefore don't understand them.
at last someone explained it clearly)
Excellent
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?
Perfect
Thanks
😀
LIFESAVER!!!
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...
thanks bro.
how do we know how many rows we will get from group by cube?
amazing
Nicely explained, very clear😊
Thank you 🙂
Sir group by ek se jyada columns ke base pe perform to skit hai
Cube function is not available in google bigquery. is their any other alternative ?
Where is link for script
impressiv
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.
#1064 limit 0,25 error @groupby grouping sets
what is this the name of software.
Postgrass sql
Present sir
Bro, this is very good, thank you for enlightening me!
My pleasure!
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;
Thank you so much!!!