ETL Testing - SQL Interview Questions - Rank(), Dense_Rank() and Row_Number understanding

Tester Hoon
Tester Hoon
2.3 هزار بار بازدید - 2 سال پیش - ETL Testing - Rank Functions
ETL Testing - Rank Functions understanding

What is RANK function in SQL?

What is difference between RANK () row_number () and Dense_rank () in SQL?

How do you find top 5 salary in SQL?
What is ROW_NUMBER () over in SQL?

// https://www.programiz.com/sql/online-...

create table Rank_Test(id int(10), emp_name varchar(100), emp_salary int(10));

insert into Rank_Test (id, emp_name, emp_salary ) values (1, 'Ravi', 1000);
insert into Rank_Test (id, emp_name, emp_salary ) values (2, 'Shyaam', 2000);
insert into Rank_Test (id, emp_name, emp_salary ) values (3, 'Pooja', 3000);
insert into Rank_Test (id, emp_name, emp_salary ) values (4, 'Neha', 4000);
insert into Rank_Test (id, emp_name, emp_salary ) values (5, 'Anuj', 4000);
insert into Rank_Test (id, emp_name, emp_salary ) values (6, 'Manu', 4000);
insert into Rank_Test (id, emp_name, emp_salary ) values (7, 'Adi', 5000);

select *, rank() over (order by emp_salary desc) rank_of_emp, dense_rank () over (order by emp_salary desc) dense_rank_emp, row_number
2 سال پیش در تاریخ 1401/07/11 منتشر شده است.
2,359 بـار بازدید شده
... بیشتر