Learn GROUP BY vs PARTITION BY in SQL

Подписаться 23 тыс.

Просмотров 38 тыс.

50% 1

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

Опубликовано:

8 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 111

@Findawaytomak3it 7 месяцев назад

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

@AnthonySmoak 7 месяцев назад

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

@Findawaytomak3it 7 месяцев назад

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

@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 11 месяцев назад

@thehunter11 3 месяца назад

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

@AnthonySmoak 3 месяца назад

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

@godwinnwaokike 5 месяцев назад

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 5 месяцев назад

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 7 месяцев назад

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 7 месяцев назад

Glad I help you learn something new!

@luistrejo2987 5 месяцев назад

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 5 месяцев назад

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.

@kanchan-kulkarni407 11 месяцев назад

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 11 месяцев назад

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.

@fidi7400 3 месяца назад

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

@AnthonySmoak 3 месяца назад

Fantastic, glad to hear that you learned something new!

@gospelmoto2833 11 дней назад

That was a great vid. It nailed to my question. Newbie here. Thanks for sharing.

@AnthonySmoak 10 дней назад

@@gospelmoto2833 Thanks for the comment!

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

@seshulatha 11 месяцев назад

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

@AnthonySmoak 11 месяцев назад

Glad it helped!

@AnthonySmoak 2 года назад

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

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

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

@BedirBayar Месяц назад

That was a crystal clear lesson. Thanks

@AnthonySmoak Месяц назад

@@BedirBayar Thanks for the comment!

@kailashsathia3080 3 месяца назад

LOVE YOUR CONTENT. HELPED ME A TON AT WORK.

@AnthonySmoak 3 месяца назад

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

@brickmedusa 5 месяцев назад

Thank you so much finally inwas able to understand this concept

@obafemijoel6706 5 месяцев назад

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 5 месяцев назад

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

@s961201 11 месяцев назад

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

@AnthonySmoak 11 месяцев назад

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!

@testpurpose5845 Год назад

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

@aspirationalaudio4025 3 месяца назад

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

@AnthonySmoak 3 месяца назад

Thank you for supporting the channel!

@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/

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

@ChrisSmithFW 5 месяцев назад

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

@AnthonySmoak 5 месяцев назад

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

@whitemask-Community 10 месяцев назад

Great Vid, Informative, Crisp, Clear 👌👍

@MrAlgorhythm 2 года назад

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

@AnthonySmoak 2 года назад

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

@shyiamnot212 Год назад

Very understandable content. It explained the concept very detailed.

@AnthonySmoak Год назад

Thank you!

@kseniyab2359 6 месяцев назад

Super useful, thank you! 💚

@AnthonySmoak 6 месяцев назад

Thank you!

@Craeson1 Год назад

Thank you for the clear explanation

@AnthonySmoak Год назад

Glad the video helped break down the differences for you!

@A_View_From_The_Shire Год назад

Very clear. Thank you!

@AnthonySmoak Год назад

Much appreciated!

@LovelyJordy Год назад

Loved this thank you Anthony 🎉.

@AnthonySmoak Год назад

Thanks for the comment Jordan

@pa-ogaming4004 Год назад

Thank you very much !!

@AnthonySmoak Год назад

Glad you enjoyed the video!

@sabinsesumariyan3687 8 месяцев назад

great thanks anthony

@AnthonySmoak 8 месяцев назад

Thanks for the comment!

@sylviejohnsimagorganics3575 Год назад

Amazing, thank you!!

@aichoices7174 Год назад

thanks for ur explanatiom

@AnthonySmoak Год назад

Thanks for watching and leaving a comment!

@saystephen7811 21 день назад

i love it

@AnthonySmoak 21 день назад

Thank you?

@amrishasritharan2617 Год назад

Dope !!!

@ashokchampati9503 Год назад

Awesome 👍

@AnthonySmoak Год назад

Thank you!

@saurabh1812 Год назад

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

@HanmyoGeorge 4 месяца назад

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

@FlyingDutchman5705 Год назад

Thank you

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

@patrickmaldonado229 Год назад

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

@AnthonySmoak Год назад

Perhaps I'll make a short.

@dispelDarkness_21 4 месяца назад

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

@pothamshettyakshay-e2b Год назад

we can do the same example by using group by

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