Learn GROUP BY vs PARTITION BY in SQL

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

[@Findawaytomak3it]

Dude, I havent even finished watching the video yet...had to pause it to PARTITION a Subscribe and Like. AWESOME WORK ANTHONY!!!!!!

[@AnthonySmoak]

This is one the best comments I've ever read on one of my videos! Thanks for making my day 😂

[@Findawaytomak3it]

@@AnthonySmoak Im glad it made your day. Keep rock'n on brother!🙂

[@thehunter11]

We're having a serious PARTITIONING case here. You the truth man, thanks.

[@AnthonySmoak]

You're the real MVP, thanks for the comment!

[@saurabhbhende4231]

best video I found on youtube which explains diff between GROUP BY and PARTITION BY so clearly, thanks a lot for the video...

[@AnthonySmoak]

Thanks for the kind words!

[@andresgutierrez7504]

x2

[@godwinnwaokike]

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.

[@AnthonySmoak]

It can be a bit confusing, but I find that a good sports example helps make the differences understandable. Thanks for sharing your comment!

[@klausbighi7045]

I didn't found a better example and a clearer approach even in my native language. Great video!

[@AnthonySmoak]

Thank you for sharing!

[@shannont44]

Dope example! Was able to take your example and apply it to some actual real work problems.

[@AnthonySmoak]

Glad to hear this, thanks anks for the comment!

[@katholloman1922]

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!

[@AnthonySmoak]

Glad I help you learn something new!

[@BedirBayar]

That was a crystal clear lesson. Thanks

[@AnthonySmoak]

@@BedirBayar Thanks for the comment!

[@luistrejo2987]

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

[@AnthonySmoak]

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.

[@kailashsathia3080]

LOVE YOUR CONTENT. HELPED ME A TON AT WORK.

[@AnthonySmoak]

I'm very glad to hear that, thanks for sharing!

[@kanchan-kulkarni407]

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!.

[@AnthonySmoak]

Thank you for sharing!

[@brandongarza1366]

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!

[@AnthonySmoak]

Thanks for this feedback! I try to make content relevant to concepts outside of business data every now and then.

[@ChrisSmithFW]

Great stuff! Thanks so much. And that's Shaq and Penny.

[@AnthonySmoak]

Thank you, Shaq and Penny should have won many championships together!🏆

[@seshulatha]

I got full clarity after watching this video ..thank you for this excellent explanation 🎉

[@AnthonySmoak]

Glad it helped!

[@kennymontero8610]

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.

[@AnthonySmoak]

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?!

[@fidi7400]

Thanks so much, you really helped me understanding grouping by and partition by. My lines of code now work as intended!

[@AnthonySmoak]

Fantastic, glad to hear that you learned something new!

[@monicabright2903]

Thank you for this! this was so so super easy, simple and straightforward to understand. thank you.

[@AnthonySmoak]

I appreciate you sharing this comment. Thank you Monica!

[@andigashi4852]

excellent! You are the only one that explained this subject for my understanding.Thank you!

[@AnthonySmoak]

Thank you for the comment! Glad you learned something new.

[@AnthonySmoak]

Has this video helped you understand the PARTITION BY concept? What use cases have you used the statement to help you complete?

[@simpleandminimalmaybe]

yes, and thank you very much for explaining in a clear and concise manner. greatly appreciate it.

[@AnthonySmoak]

@@simpleandminimalmaybe Wonderful! Thanks for the feedback

[@kseniyab2359]

Super useful, thank you! 💚

[@AnthonySmoak]

Thank you!

[@brickmedusa]

Thank you so much finally inwas able to understand this concept

[@obafemijoel6706]

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?

[@AnthonySmoak]

Certainly, just apply the formula for percent difference from the average.

[@s961201]

Great video!!! So educational - very pedagogically explained. Thanks!

[@AnthonySmoak]

Thank you so much for the feedback!

[@asqalith6998]

You are amazing , you made this topic so simple for me

[@AnthonySmoak]

I appreciate the comment, thank you!

[@wilshawn3347]

Great stuff and well executed, The concept is now very clear to me. Thank you,👍

[@AnthonySmoak]

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!

[@wilshawn3347]

Hi Anthony, can you kindly share the NBA data used in this video? I would like that for my learning

[@AnthonySmoak]

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/

[@aspirationalaudio4025]

Really Thank you for your explanation 😍😍 a New Like and subscription From Egypt 🤙

[@AnthonySmoak]

Thank you for supporting the channel!

[@shyiamnot212]

Very understandable content. It explained the concept very detailed.

[@AnthonySmoak]

Thank you!

[@whitemask-Community]

Great Vid, Informative, Crisp, Clear 👌👍

[@MrAlgorhythm]

Well explained, clear, usefull, and accompanied by smooth beats to boot.

[@AnthonySmoak]

Thank you for sharing! I'm aIways grateful when a video helps someone understand. Glad you dig the tunes as well.

[@pa-ogaming4004]

Thank you very much !!

[@AnthonySmoak]

Glad you enjoyed the video!

[@kiranyeluru7392]

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

[@AnthonySmoak]

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!

[@Craeson1]

Thank you for the clear explanation

[@AnthonySmoak]

Glad the video helped break down the differences for you!

[@sabinsesumariyan3687]

great thanks anthony

[@AnthonySmoak]

Thanks for the comment!

[@aichoices7174]

thanks for ur explanatiom

[@AnthonySmoak]

Thanks for watching and leaving a comment!

[@A_View_From_The_Shire]

Very clear. Thank you!

[@AnthonySmoak]

Much appreciated!

[@LovelyJordy]

Loved this thank you Anthony 🎉.

[@AnthonySmoak]

Thanks for the comment Jordan

[@testpurpose5845]

Great explanation . I really appreciate . Btw where can I find the sql table entries ?

[@saystephen7811]

i love it

[@AnthonySmoak]

Thank you?

[@sylviejohnsimagorganics3575]

Amazing, thank you!!

[@dispelDarkness_21]

bro, nice one. An humble request: kindly turn off background music, its bothering.

[@amrishasritharan2617]

Dope !!!

[@HanmyoGeorge]

Great Tutorial! The background sound was a little distracting for me

[@patrickmaldonado229]

A show of running total using partition by would have been great.

[@AnthonySmoak]

Perhaps I'll make a short.

[@ashokchampati9503]

Awesome 👍

[@AnthonySmoak]

Thank you!

[@saurabh1812]

what if we have duplicate values in tables? how row_number function will work?

[@FlyingDutchman5705]

Thank you

[@pothamshettyakshay-e2b]

we can do the same example by using group by

[@sylviejohnsimagorganics3575]

Sorry if you've already answered this but which one is better from a performance point of view?

[@AnthonySmoak]

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.

[@sylviejohnsimagorganics3575]

@@AnthonySmoak thank you so much. Can't wait to use Partition By soon, I didn't know about it at all!

[@dbanoob]

LOL @ the random Shaq/Penny

[@AnthonySmoak]

Good catch!

[@hatersgotohell627]

6:53 How come you didn't need to group by the team column as well?

[@AnthonySmoak]

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.

[@pabitrakb5291]

Nice explanation But background sound is a bit irritating

[@shirazahmed5944]

Ok but how can I convert this into LINQ?

[@AnthonySmoak]

That is not my area of knowledge, start with ChatGPT.

[@3170ccp]

Is this for oracle?

[@AnthonySmoak]

I'm using SQL Server but give Oracle a try.

[@PURVAMARGAJ-j3b]

share data

[@paulpostma6520]

Would better without the music - too distracting

[@seshulatha]

No background music please

[@AnthonySmoak]

Video is already released. Too late! ;)

[@nishasilori4222]

Please if possible avoid using the background noise while teaching

[@AnthonySmoak]

But I like "noise" 😂 #music

[@TheBinary0101]

Super !! thx lots .. subscribed

[@AnthonySmoak]

Much appreciated!