Learn GROUP BY vs PARTITION BY in SQL

Details
Title | Learn GROUP BY vs PARTITION BY in SQL |
Author | Anthony Smoak |
Duration | 14:02 |
File Format | MP3 / MP4 |
Original URL | https://youtube.com/watch?v=wN1egFA2GvU |
Description
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
If you love this video but want a version without the music, please consider becoming a channel member and watch the members only version here:
► https://www.youtube.com/watch?v=bFfXyv5Cz0U
★☆★ Join this channel to get access to perks: ★☆★
https://www.youtube.com/channel/UCL2ls5uXExB4p6_aZF2rUyg/join
★☆★ FOLLOW ME BELOW: ★☆★
Blog ► https://anthonysmoak.com/
Bluesky► https://bsky.app/profile/anthonysmoak.bsky.social
Facebook ► https://www.facebook.com/AnthonyBSmoak/
Instagram ► https://Instagram.com/@anthonysmoakdata
Tableau Public ► https://bit.ly/3JMKsLY