Open In App

GATE | GATE CS Mock 2018 | Question 19

Like Article
Like
Save
Share
Report

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


Last Updated : 25 Jun, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads