ANY answer.
Re: Get Max Salary at any rank
[sql]select salary from(
select a1.salary,count(a2.salary)sal
from salarytable a1,salarytable a2
where a1.salary<=a2.salary or (a1.salary=a2.salary)
group by a1.salary)a where sal=4 [/sql]
Here 4 specifies Max salary at fourth position
|