Windows Function What is Rank and Desnse Rank in SQL End to End Guide

Описание: Learn the difference between RANK and DENSE RANK in MySQL in this end-to-end guide!

In this video, we'll cover the following topics:

What are RANK and DENSE RANK?
How do they work?
When should you use each one?
Examples of how to use RANK and DENSE RANK in MySQL

The RANK and DENSE_RANK functions are both used to assign ranks to rows in a result set. However, there is one key difference between the two functions: RANK skips ranks when there are ties, while DENSE_RANK does not.

SELECT
name,
score,
RANK() OVER (ORDER BY score DESC) AS rank,
DENSE_RANK() OVER (ORDER BY score DESC) AS dense_rank
FROM students;
----
name score rank dense_rank
Alice 100 1 1
Bob 90 2 2
Carol 90 2 3
Dave 80 4 4


----
As you can see, the RANK function assigns the rank of 2 to both Bob and Carol, even though they have the same score. This is because RANK skips ranks when there are ties. The DENSE_RANK function, on the other hand, does not skip ranks. This means that Carol is assigned the rank of 3, even though she has the same score as Bob.

In general, you should use RANK when you want to skip ranks when there are ties. You should use DENSE_RANK when you want to assign consecutive ranks, even when there are ties.

Here are some additional examples of how RANK and DENSE_RANK can be used:

You could use RANK to determine the top 10 students in a class.
You could use DENSE_RANK to determine the overall ranking of a group of athletes, even if some of the athletes have the same score.
You could use RANK to determine the position of a product in a search results page.
You could use DENSE_RANK to determine the position of a product in a list of products that are sorted by price.


I am Mr. Surani ,Data Science Aspirant. I will teach you different technical hacks to horn up your expertise on Python, R , Data Science, Machine Learn, Tableau, Apache, MS Excel. Photoshop Tutorials, Adobe Premiere m Adobe After effects , MS Words, Power Points , Windows Hacks etc


Sponser Link : https://www.everbee.io/?via=mayurkumar
link : https://shorturl.at/dkHOW

Please note, these links are affiliate links, which means that I may get a commission or reward if you click on them & signup, or purchase something through these links. Using them is entirely optional but it is always appreciated!

►► 40 FREE ITEMS ETSY: https://etsy.me/42ntFXb (not my affiliate link)


Please, Like , Share and hit bell icon in Channel. Thank you

sql,mysql,ms sql,sql tutorial,learn sql,sql for beginners,interview sql,data analytics sql,sql data analytics,sql tutorial for beginners,sql basics,sql course,sql training,sql videos,sql crash course,sql beginners,sql full course,free sql course,sql basics for beginners,introduction to sql,learn sql fast,learn sql for beginners,sql beginner,basic sql,sql basics tutorial,sequel,sql commands,SELECT,Simple SQL Queries,SQL Queries,SQL operators

#mysql
#sql
#ranking
#denserank
#rank
#mysqltutorial
#sqltutorial
#database
#datascience