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.
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!
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.
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!
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.
Sir, referring to 12:40, you've used ORDER BY in line-7. Can we use it in lines 8, 9 & 10 as well simultaneously? Or will that result into error? Also, which is more efficient to use: GROUPing or PARTITIONing?
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!
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/
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?
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!
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.
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.
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!🙂
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
We're having a serious PARTITIONING case here. You the truth man, thanks.
You're the real MVP, thanks for the comment!
I didn't found a better example and a clearer approach even in my native language. Great video!
Thank you for sharing!
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!
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!
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.
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!
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!
That was a crystal clear lesson. Thanks
@@BedirBayar Thanks for the comment!
I got full clarity after watching this video ..thank you for this excellent explanation 🎉
Glad it helped!
That was a great vid. It nailed to my question. Newbie here. Thanks for sharing.
@@gospelmoto2833 Thanks for the comment!
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.
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! You are the only one that explained this subject for my understanding.Thank you!
Thank you for the comment! Glad you learned something new.
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!
LOVE YOUR CONTENT. HELPED ME A TON AT WORK.
I'm very glad to hear that, thanks for sharing!
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 so much finally inwas able to understand this concept
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?!
Great video!!! So educational - very pedagogically explained. Thanks!
Thank you so much for the feedback!
You are amazing , you made this topic so simple for me
I appreciate the comment, thank you!
Great stuff! Thanks so much. And that's Shaq and Penny.
Thank you, Shaq and Penny should have won many championships together!🏆
Really Thank you for your explanation 😍😍
a New Like and subscription From Egypt 🤙
Thank you for supporting the channel!
Great Vid, Informative, Crisp, Clear 👌👍
Sir, referring to 12:40, you've used ORDER BY in line-7. Can we use it in lines 8, 9 & 10 as well simultaneously? Or will that result into error?
Also, which is more efficient to use: GROUPing or PARTITIONing?
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/
Thank you for the clear explanation
Glad the video helped break down the differences for you!
Super useful, thank you! 💚
Thank you!
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.
Very understandable content. It explained the concept very detailed.
Thank you!
great thanks anthony
Thanks for the comment!
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.
Great explanation . I really appreciate .
Btw where can I find the sql table entries ?
Very clear. Thank you!
Much appreciated!
Thank you very much !!
Glad you enjoyed the video!
Amazing, thank you!!
Loved this thank you Anthony 🎉.
Thanks for the comment Jordan
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!
thanks for ur explanatiom
Thanks for watching and leaving a comment!
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.
Awesome 👍
Thank you!
what if we have duplicate values in tables? how row_number function will work?
A show of running total using partition by would have been great.
Perhaps I'll make a short.
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!
i love it
Thank you?
Dope !!!
Is this for oracle?
I'm using SQL Server but give Oracle a try.
Thank you
Great Tutorial! The background sound was a little distracting for me
bro, nice one.
An humble request: kindly turn off background music, its bothering.
Ok but how can I convert this into LINQ?
That is not my area of knowledge, start with ChatGPT.
we can do the same example by using
group by
LOL @ the random Shaq/Penny
Good catch!
Nice explanation
But background sound is a bit irritating
share data
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!