SQL Ranking Window Functions | ROW_NUMBER, RANK, DENSE_RANK, NTILE, CUME_DIST, PERCENT_RANK

Published: 14 May 2024
on channel: Data with Baraa

14,898

669

🎬 Full Advanced Course:    • How I'd Learn Advanced SQL and Why (I...
⬇️ Free Materials (Downloads): https://datawithbaraa.substack.com
👉 Support & Subscribe to Channel: http://bit.ly/3GiCVUE

☕ Stay connected
► Subscribe: http://bit.ly/3GiCVUE
► LinkedIn:   / baraa-khatib-salkini
► Website: https://www.datawithbaraa.com
► Newsletter: https://bit.ly/BaraaNewsletter
► PayPal: https://paypal.me/baraasalkini
► Join:    / @datawithbaraa

📚 Free Courses
✅ Tableau:    • Complete HR Tableau Project End-to-En...
✅ Tableau Project:    • Complete HR Tableau Project End-to-En...
✅ SQL Basics:    • SQL Tutorial for Beginners [Ultimate ...
✅ SQL Advanced:    • How I'd Learn Advanced SQL and Why (I...
✅ ChatGPT:    • ChatGPT Tutorial for Beginners [Ultim...

🎓Other Platforms (Certifications)
► Udemy: https://bit.ly/BaraaUdemy
► Skillshare (1 Free Month): https://bit.ly/BaraaSkillshare

⭐ My favorite books: https://kit.co/DataWithBaraa/my-favor...
💻 My gear: https://kit.co/DataWithBaraa/my-deskt...

⏱️ Timestamp
00:00 Intro
00:00:28 What are Window Ranking Functions?
00:05:48 ROW_NUMBER
00:10:13 RANK
00:14:18 DENSE_RANK
00:18:42 ROW_NUMBER vs RANK vs DENSE_RANK
00:19:45 ROW_NUMBER: TOP-N Analysis
00:23:24 ROW_NUMBER: Bottom-N Analysis
00:27:00 ROW_NUMBER: Assign Unique IDs
00:29:47 ROW_NUMBER: Identify Duplicates
00:35:21 NTILE
00:41:41 NTILE: Data Segmentation
00:45:35 NTILE: Equalizing Loads
00:49:02 Intro Percentage Based Ranking
00:50:10 CUME_DIST
00:53:52 PERCENT_RANK
01:01:40 Summary

#sql #sqlserver #data #analytics
*Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

Watch video SQL Ranking Window Functions | ROW_NUMBER, RANK, DENSE_RANK, NTILE, CUME_DIST, PERCENT_RANK online without registration, duration hours minute second in high quality. This video was added by user Data with Baraa 14 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 14,898 once and liked it 669 people.