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

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

🎵 Be Mine - Kamrad 🎵 Sapphire - Ed Sheeran 🎵 Mystical Magical - Benson Boone 🎵 Just The Way You Are - Bruno Mars 🎵 Die With A Smile - Lady Gaga & Bruno Mars 🎵 Get Lucky - Daft Punk Feat. Pharrell… 🎵 Titanium - David Guetta Feat. Sia 🎵 Pas Jalouse - Bamby & Kerchak 🎵 Rolling In The Deep - Adele 🎵 Irl - Lizzo & Sza 🎵 4X4 - Travis Scott 🎵 Jump - Blackpink