MP3JOSS

Learn GROUP BY vs PARTITION BY in SQL

Learn GROUP BY vs PARTITION BY in SQL

Choose Download Format

Download MP3 Download MP4

Details

TitleLearn GROUP BY vs PARTITION BY in SQL
AuthorAnthony Smoak
Duration14:02
File FormatMP3 / MP4
Original URL https://youtube.com/watch?v=wN1egFA2GvU
🎵 Support the artists — buy the original for the best audio quality! 🎵

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

🎧 Just For You

🎵 Abracadabra - Lady Gaga 🎵 Azizam - Ed Sheeran 🎵 Wake Me Up - Avicii 🎵 We Found Love - Rihanna Feat. Calvin… 🎵 Not Like Us - Kendrick Lamar 🎵 - Emin & Jony 🎵 Die With A Smile - Lady Gaga & Bruno Mars 🎵 Just The Way You Are - Bruno Mars 🎵 Daisies - Justin Bieber 🎵 Wassup - Young Miko 🎵 Roar - Katy Perry 🎵 The Giver - Chappell Roan