View Single Post
  #20 (permalink)  
Old 02-20-2008, 09:26 AM
Suraj Dhandal
 
Posts: n/a
Default 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
Reply With Quote