Learn GROUP BY vs PARTITION BY in SQL
Vložit
- čas přidán 22. 08. 2024
- While the Group BY clause is fairly standard in SQL, most people do not understand when to use the PARTITION BY clause. This easy to understand video uses some NBA season data to make the point very clear! I will show you the best use case of when to apply PARTITION BY.
#SQL #analytics #tsql #groupby #dataanalyst #data
★☆★ Join this channel to get access to perks: ★☆★
/ @anthonysmoak
★☆★ FOLLOW ME BELOW: ★☆★
Blog ► anthonysmoak.com/
Twitter ► / anthonysmoak
Facebook ► / anthonybsmoak
Instagram ► / @anthonysmoakdata
Tableau Public ► bit.ly/3JMKsLY
Dude, I havent even finished watching the video yet...had to pause it to PARTITION a Subscribe and Like. AWESOME WORK ANTHONY!!!!!!
This is one the best comments I've ever read on one of my videos! Thanks for making my day 😂
@@AnthonySmoak Im glad it made your day. Keep rock'n on brother!🙂
We're having a serious PARTITIONING case here. You the truth man, thanks.
You're the real MVP, thanks for the comment!
best video I found on youtube which explains diff between GROUP BY and PARTITION BY so clearly, thanks a lot for the video...
Thanks for the kind words!
x2
I didn't found a better example and a clearer approach even in my native language. Great video!
Thank you for sharing!
Dope example! Was able to take your example and apply it to some actual real work problems.
Glad to hear this, thanks anks for the comment!
Just yesterday, I was frustrated at not being able to understand the PARTITION BY clause after trying to. Today, your video has solved that for me in a spectacular way. Thank you.
It can be a bit confusing, but I find that a good sports example helps make the differences understandable. Thanks for sharing your comment!
this has been one of the most insighful videos i´ve seen so far in my journey of SQL learning, THANKS for this, it has clarified a lot of things! You´ve got yourself a new sub
Thank you so much for sharing this comment Luis! It's a lot of work to run this channel and I appreciate viewers who share that my videos are making a difference.
Has this video helped you understand the PARTITION BY concept? What use cases have you used the statement to help you complete?
yes, and thank you very much for explaining in a clear and concise manner. greatly appreciate it.
@@simpleandminimalmaybe Wonderful! Thanks for the feedback
Thank you. Partition by was a topic we absolutely covered in college, but I didn’t think much of it. Now that I’m in the field, I’m in a situation where I need to understand partition by for this project. Now I have that knowledge, thanks!
Glad I help you learn something new!
Thanks so much, you really helped me understanding grouping by and partition by. My lines of code now work as intended!
Fantastic, glad to hear that you learned something new!
Excellent content, this really helped me understand this concept. Using a real world example for things I actually care about makes this much more engaging too. Thanks!
Thanks for this feedback! I try to make content relevant to concepts outside of business data every now and then.
LOVE YOUR CONTENT. HELPED ME A TON AT WORK.
I'm very glad to hear that, thanks for sharing!
This is the best video I found which explains diff between GROUP BY and PARTITION BY so clearly, that helped me a lot. thank you very much!.
Thank you for sharing!
I got full clarity after watching this video ..thank you for this excellent explanation 🎉
Glad it helped!
Usually never comment on these kind of videos but this one I had to. Amazing tutorial with a real life topic/example that is interesting. I was cracking up at "2021 Play in Game Champs". Subscribed and Liked. Appreciate you boss.
Thanks for taking the time to comment. It helps content be discovered. Can you imagine the celebration if the TWolves won an actual NBA title?!
Thank you for this! this was so so super easy, simple and straightforward to understand. thank you.
I appreciate you sharing this comment. Thank you Monica!
excellent! You are the only one that explained this subject for my understanding.Thank you!
Thank you for the comment! Glad you learned something new.
Great stuff! Thanks so much. And that's Shaq and Penny.
Thank you, Shaq and Penny should have won many championships together!🏆
This is really insightful Anthony! You explained it in a very simple fashion. Wanted asking to know if I can get a percentage difference for the points instead of just the difference from the average?
Certainly, just apply the formula for percent difference from the average.
You are amazing , you made this topic so simple for me
I appreciate the comment, thank you!
Thank you so much finally inwas able to understand this concept
Super useful, thank you! 💚
Thank you!
Great stuff and well executed, The concept is now very clear to me. Thank you,👍
I'm glad you shared that my video helped make the concept clear. It makes my day when someone learns something new from what I create and share. Thank you!
Hi Anthony, can you kindly share the NBA data used in this video? I would like that for my learning
I don't usually share datasets (because I get more requests than I have time to respond to) but share your email here and I'll see what I can do. You can hunt for similar stats at www.basketball-reference.com/
Great video!!! So educational - very pedagogically explained. Thanks!
Thank you so much for the feedback!
Really Thank you for your explanation 😍😍
a New Like and subscription From Egypt 🤙
Thank you for supporting the channel!
Very understandable content. It explained the concept very detailed.
Thank you!
Thank you very much !!
Glad you enjoyed the video!
Great Vid, Informative, Crisp, Clear 👌👍
Well explained, clear, usefull, and accompanied by smooth beats to boot.
Thank you for sharing! I'm aIways grateful when a video helps someone understand. Glad you dig the tunes as well.
Thank you for the clear explanation
Glad the video helped break down the differences for you!
great thanks anthony
Thanks for the comment!
Wonderful Next level of teaching Anthony, Really great to watch difficult topic you made it as easy , Could you please suggest some good books to learn MySQL , Anthony
Thanks for the kind works Kiran! There are many courses around to learn MySQL. I dont have a particular recommendation, but just pick one and go for it!
Very clear. Thank you!
Much appreciated!
thanks for ur explanatiom
Thanks for watching and leaving a comment!
Loved this thank you Anthony 🎉.
Thanks for the comment Jordan
Amazing, thank you!!
Dope !!!
Great explanation . I really appreciate .
Btw where can I find the sql table entries ?
A show of running total using partition by would have been great.
Perhaps I'll make a short.
Awesome 👍
Thank you!
bro, nice one.
An humble request: kindly turn off background music, its bothering.
Great Tutorial! The background sound was a little distracting for me
Thank you
LOL @ the random Shaq/Penny
Good catch!
what if we have duplicate values in tables? how row_number function will work?
Sorry if you've already answered this but which one is better from a performance point of view?
These are two different operations with different use cases. However, given the need to arrive at an aggregated number, I believe the GROUP BY would provide better performance.
@@AnthonySmoak thank you so much. Can't wait to use Partition By soon, I didn't know about it at all!
we can do the same example by using
group by
6:53 How come you didn't need to group by the team column as well?
At that point I am not grouping, I am simply displaying the dimensions. The Over and Partition By help calculate the overall sum of points by each distinct value in the Conference.
Nice explanation
But background sound is a bit irritating
share data
Is this for oracle?
I'm using SQL Server but give Oracle a try.
Ok but how can I convert this into LINQ?
That is not my area of knowledge, start with ChatGPT.
No background music please
Video is already released. Too late! ;)
Would better without the music - too distracting
Please if possible avoid using the background noise while teaching
But I like "noise" 😂 #music
Super !! thx lots .. subscribed
Much appreciated!