In this video we are going to learn about rank and dense rank functions and
understand their difference.
According to the definition, rank function will skip the rankings of rows containing same values while dense rank will not. Let us understand that with help of example in the video.
Website - https://thedatamonk.com/
SQL Complete Playlist - • SQL Data Science Interview Questions
Case Study Complete Playlist - • Case Studies, Guesstimates and Data Scienc...
We at The Data Monk aims at bridging the gap between theoretical knowledge and cracking an interview in Analytics domain.
Analytics domain includes:-
-Data Analysts
-Data Scientists
-Business Analysts
-Product Analysts
-Decision Scientists and similar roles
We currently have 30+ e-books on Amazon to prepare for Data Science interviews
You can also buy our set 10 e-books which covers 1400+ solved Interview Questions from here - https://thedatamonk.com/buy-e-books/
Please check our free resources:-
30+ companies complete interview questions - https://thedatamonk.com/analytics-int...
300+ Solved Python Questions - https://thedatamonk.com/python-questi...
300+ Solved SQL Questions - https://thedatamonk.com/sql-interview...
100+ Solved Case Studies and Guesstimates - https://thedatamonk.com/case-study-fo...
100+ Solved Interview Questions in R - https://thedatamonk.com/r-interview-q...
300 + Solved Machine Learning and Statistics Questions - https://thedatamonk.com/most-asked-ma...
200+ Solved Statistics Interview Questions - https://thedatamonk.com/statistics-da...
You can create your account on https://thedatamonk.com and participate in our Daily Quizzes and weekly free e-book giveaway by creating an account and subscribing to the website -https://thedatamonk.com/the-data-monk...
On this page of the site you can watch the video online Rank() vs Dense_Rank() in SQL | Part 8 | Data Science Interview Questions | The Data Monk with a duration of hours minute second in good quality, which was uploaded by the user The Data Monk 16 June 2021, share the link with friends and acquaintances, this video has already been watched 1,479 times on youtube and it was liked by 23 viewers. Enjoy your viewing!