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

Опубликовано: 14 Май 2024
на канале: Data with Baraa

35,018

1.4k

🎬 SQL Full (30-Hours) Course    • SQL Full Course for Beginners (30 Hours) –...
🎁 Free Downloads & Materials: https://datawithbaraa.substack.com
👉 Support & Subscribe to Channel: http://bit.ly/3GiCVUE

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

📚 Free Courses
✅ Python :    • Python Bootcamp Playlist (2025) - Zero to ...
✅ SQL :    • SQL Full Course for Beginners (30 Hours) –...
✅ Tableau :    • Complete HR Tableau Project End-to-End | L...
✅ Tableau Project 1 :    • Tableau Complete Project End-to-End | Like...
✅ Tableau Project 2 :    • Complete HR Tableau Project End-to-End | L...
✅ SQL Project1 :    • SQL Data Warehouse from Scratch | Full Han...
✅ SQL Project2 :    • SQL Data Analyst Portfolio Project | Like ...
✅ MySQL :   • SQL Tutorial for Beginners [Ultimate Full ...

🎓 If You Need Certifications
🏅´Udemy SQL: https://bit.ly/4hH947P
🏅 Udemy Tableau: https://bit.ly/3xFiDDk

⭐ My favorite books, gear, apps: https://bit.ly/baraastuff

⏱️ 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