ETL Testing - SQL Interview Questions - Rank(), Dense_Rank() and Row_Number understanding
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
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
بـار بازدید شده