nth highest salary

[sudharsong]

hi all, i just want to know how to get the nth highest salary from employee table.any help appreciated.

with regards, susa

[Arvind Srivastava]

select top 1 sal from (select top 6 from emp order by sal asc) order by sal desc

[Ainapuram]

Try this SELECT empid,MAX(Salary) FROM Employees WHERE EmpID IN (SELECT TOP 2 EmpID FROM Employees ORDER BY Salary Desc) Muralidhar

[sudharsong]

hi, when im executed this query i got only the first two higher values even if i speciofied top 5 values thanks

with regards, susa

[sudharsong]

hi boss , At last i got a solution for that problem. i used this one select min(sal) from(SELECT distinct TOP n sal FROM account ORDER BY Sal desc) as newsalary here instead of n we can give what ever the highest number we need.

with regards, susa

[Paul Conrad]

Look at this thread a while back[^], I tested EricDV's suggestion and it works. Paul

---

That's no moon, it's a space station. - Obi-wan Kenobi