Skip to content
Related Articles

Related Articles

Improve Article
GATE | GATE CS Mock 2018 | Question 19
  • Last Updated : 25 Jun, 2018

Consider the following relational schema:

EmployeeDetail (EmpId, FullName, ManagerID, DateOfJoining)
EmployeeSalary (EmpID, Project, Salary)

Consider the following relational query on the above database:

SELECT Salary
FROM EmployeeSalary Emp1
WHERE 2 = (
                SELECT COUNT( DISTINCT ( Emp2.Salary ) )
                FROM EmployeeSalary Emp2
                WHERE Emp2.Salary > Emp1.Salary
            )

Assume that relations corresponding to the above schema are not empty. Which one of the following is the correct interpretation of the above query?
(A) find the highest salary from table
(B) find the 2nd highest salary from table
(C) find the 3rd highest salary from table
(D) None of above


Answer: (C)

Explanation: For nth highest salary-

SELECT Salary
FROM EmployeeSalary Emp1
WHERE n-1 = (
                SELECT COUNT( DISTINCT ( Emp2.Salary ) )
                FROM EmployeeSalary Emp2
                WHERE Emp2.Salary > Emp1.Salary
            )

Option (C) is correct.

Quiz of this Question

Attention reader! Don’t stop learning now. Learn all GATE CS concepts with Free Live Classes on our youtube channel.

My Personal Notes arrow_drop_up
Recommended Articles
Page :