Find Nth highest salary of table

Satyapriyanayak
Posted by Satyapriyanayak under Sql Server category on | Points: 40 | Views : 797
select distinct(salary) from employee A where n=(select count(distinct(salary)) from employee B where A.salary<=B.salary)

Comments or Responses

Login to post response