SQL Tips and Tricks - 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