SQL Interview Scenario's || SQL Interview Questions || SQL

Описание к видео SQL Interview Scenario's || SQL Interview Questions || SQL

Can you please write a query to remove the duplicate records in department 10,20 ?

Write a sql query to display the 5th and 7th highest salary records ?
Write a query to display the whose employee salary is greater than their managers salaries?

create table duplicates
(
empno integer,
ename varchar(40),
deptno integer,
sal integer
)
insert into duplicates values(1,'sri',10,2000),(2,'raju',20,3000),
(1,'sri',10,2000),(3,'sriram',30,4000),(3,'sriram',30,4000),(1,'sri',10,2000)

Комментарии

Информация по комментариям в разработке

Похожие видео