910 views
0 votes
0 votes

1 Answer

1 votes
1 votes

C. 

This is a correlated nested query. Where inner query gives a count of employee having more salary than the employee in outer query and 2 checks that only 2 people have more salary than him. 

Related questions

0 votes
0 votes
1 answer
2
rayhanrjt asked Jan 6, 2023
719 views
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
2 votes
2 votes
1 answer
3
Subhrangsu asked Jun 18, 2022
431 views
Write SQL query to show all employees hired on June 4,1984 (non-default format)emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)
1 votes
1 votes
1 answer
4
Shubhanshu asked Dec 24, 2018
1,260 views
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”