Given an Employee Table with Salary Column, Find 2nd and 5th highest salary in a particular department.

Interview Questions and Answers

Q1. Given an Employee Table with Salary Column, Find 2nd and 5th highest salary in a particular department.

Ans. Select salary from (select salary from employee where department = order by salary desc limit 5) emp order by salary limit 1 AND Select salary from (select salary from employee where department = order by salary desc limit 2) emp2 order by salary limit 1

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql database find 2nd highest salary sql database Asked in 1 Companies}