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

🎬 Full Advanced Course: • How I'd Learn Advanced...
⬇️ Free Materials (Downloads): datawithbaraa.substack.com
👉 Support & Subscribe to Channel: bit.ly/3GiCVUE
☕ Stay connected
► Subscribe: bit.ly/3GiCVUE
► Join: / @datawithbaraa
► Newsletter: bit.ly/BaraaNewsletter
► LinkedIn: / baraa-khatib-salkini
► Website: www.datawithbaraa.com
📚 Free Courses
✅ Tableau: • Complete HR Tableau Pr...
✅ Tableau Project: • Complete HR Tableau Pr...
✅ SQL Basics: • SQL Tutorial for Begin...
✅ SQL Advanced: • How I'd Learn Advanced...
✅ ChatGPT: • ChatGPT Tutorial for B...
🎓Other Platforms (Certifications)
► Udemy: bit.ly/BaraaUdemy
► Skillshare (1 Free Month): bit.ly/BaraaSkillshare
⭐ My favorite books: kit.co/DataWithBaraa/my-favor...
💻 My gear: 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*

[@DataWithBaraa]

If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE ⏱ TIMESTAMPS ⏱ --------------------------------- 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 Enjoy ☕

[@mohammadthousif7439]

Greatest tutorial on ranking functions across entire internet ever.

[@sapbo2284]

Hi Baraa, Hope you are doing well! Baraa you might don't know how much you are helping people like me.Thanks a million

[@fatmaabduarrahman7590]

I wonder why something like this doesn't have at least hundreds of thousands of views. Thanks for you efforts

[@DataWithBaraa]

With your people like you supporting, maybe my content will reach the others ❤️

[@davidcere16ceresuela28]

Hi Baraa, you don't realize how amazing your work is! Please, keep it up with the tutorials!! Thanks :)

[@DataWithBaraa]

And you don't realize how awesome you are, when you take time a writing me this nice comment 🙂

[@narragopichand9982]

I didn’t seen any videos on sql with immense detailed explanations.

[@Bhargavi-vz1zt]

Thank you Baraa! very Informative and I was able to crack my SQL interview because of your SQL videos..

[@DataWithBaraa]

Excellent! Great job 👏

[@talkwithjyoti1883]

your teaching style is mind blowing

[@DataWithBaraa]

Thanks dear ✌️

[@ransfordsaddicamoleka2924]

Thanks very much Baraa

[@santoshkiran5858]

I'm starting to get the hang of SQL from you're tutorial lecture Simply Brilliant ❤❤❤

[@DataWithBaraa]

Great to hear!

[@sowmya6471]

Thanks for introducing advance concept Cume_dist(). It is gonna help me in my office work.

[@DataWithBaraa]

Nice, it’s useful function!

[@devinanissa7928]

I really feel blessed that you made this all video. It's really interesting and easy to understand. when the 1st time i watched your video, i am immediately subscribe!! Great Job Baraa!! Thank you

[@DataWithBaraa]

I am aswell blessed to be able to reach kind people like you, thanks for the support and glad you liked it

[@My_query]

Keep doing it bro your explanation makes more sense I bet you.

[@DataWithBaraa]

Thanks

[@micaelzekarias1537]

As always I have no word to thank you. God bless u wherever u r.

[@mdanisurrahman357]

Awesome,, pls keep making more extraordinary videos

[@sarphoah]

Thank you so much Baraa! Your videos are so helpful. I appreciate the effort you put into them. Can you please do a video on handling different Date types in SQL?

[@DataWithBaraa]

Thank for the kind words, yes I’ll cover it in my course!

[@andrescorrea9640]

Outstanding! 👏🏻👏🏻👏🏻 Thank you so much!

[@azaansfunworld4300]

I am excited even before going through the video ….i am sure I m going to enjoy this … Thanqqqqqq

[@CuocSongQuanhTabolbol123]

Thanks Baraa as always!

[@jaideepthanage4934]

Was waiting for this eagerly!❤

[@golden_melodies]

Thanks alot

[@venkateshperumal4222]

Thank you so much, was waiting for this video eagerly!!!

[@DataWithBaraa]

You are welcome, i hope you will enjoy it !

[@joewerger8845]

what is the letter t after the query

[@anuboluwaji635]

Hi Baraa, hope all is well. Question: do you know MySQL and if you do, can you please do a tutorial on it?

[@jacksmith4257]

Whether all of this work same in MySQL server

[@gopikrishnasistla8896]

ITALY and SQL both are beautiful only by Baraa sir. From sales.orders) t where rank byproduct=1 Above query after bracket the letter t comes. What it mean Thank you sir

[@DataWithBaraa]

Italy is very lovely and amazing culture. The letter t that comes after the closing bracket in your query is an alias for the subquery. In SQL, you can assign an alias to a table or a subquery to simplify references to it in the rest of your query. In SQL Server it is required to give an Alias after each subquery.

[@gopikrishnasistla8896]

@@DataWithBaraa thank you sir