Difference between rank, dense rank and row number

In this video we will understand the difference between window functions rank , dense rank and row number.

Zero to hero analytics courses : https://www.namastesql.com/

script:
CREATE TABLE emp (
emp_id INT,
emp_name VARCHAR(20),
department_id INT,
salary INT,
manager_id INT,
emp_age INT
);
INSERT INTO emp VALUES (1, 'Ankit', 100, 10000, 4, 39);
INSERT INTO emp VALUES (2, 'Mohit', 100, 15000, 5, 48);
INSERT INTO emp VALUES (3, 'Vikas', 100, 10000, 4, 37);
INSERT INTO emp VALUES (4, 'Rohit', 100, 5000, 2, 16);
INSERT INTO emp VALUES (5, 'Mudit', 200, 12000, 6, 55);
INSERT INTO emp VALUES (6, 'Agam', 200, 12000, 2, 14);
INSERT INTO emp VALUES (7, 'Sanjay', 200, 9000, 2, 13);
INSERT INTO emp VALUES (8, 'Ashish', 200, 5500, 2, 12);
INSERT INTO emp VALUES (9, 'Mukesh', 300, 6000, 6, 51);
INSERT INTO emp VALUES (10, 'Rakesh', 300, 7000, 6, 50);

Zero to hero(Advance) SQL Aggregation:
https://youtu.be/5Ighj_2PGV0

Most Asked Join Based Interview Question:
https://youtu.be/xR87ctOgpAE

Solving 4 Trick SQL problems:
https://youtu.be/Ck1gQrlS5pQ

Data Analyst Spotify Case Study:
https://youtu.be/-YdAIMjHZrM

Top 10 SQL interview Questions:
https://youtu.be/Iv9qBz-cyVA

Interview Question based on FULL OUTER JOIN:
https://youtu.be/KQfWd6V3IB8

Playlist to master SQL :
https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb

Rank, Dense_Rank and Row_Number:
https://youtu.be/xMWEVFC4FOk

#sql #analytics

Видео Difference between rank, dense rank and row number канала Ankit Bansal