Article:		SQL Data Types
Subject:		how do we find nth highest in SQL
Date:		2006-04-17 07:57:07
From:		sainiks
Response to: how do we find nth highest in SQL
1. Select * from Employee where salary = (Select max(Salary) from Employee where salary < (Select max(Salary) from Employee where Salary<(Select max(Salary) from Employee where Salary <…………………………………………… N The above query can be continued n timesif you require nth highest salary 2. Select * From Employee E1 Where (N-1) = (Select Count(Distinct(E2.Salary)) From Employee E2 Where E2.Salary > E1.Salary) here you require N th highest salary Those were two choices , i think 2nd one will take a bit time.

Showing messages 1 through 2 of 2.

• how do we find nth highest in SQL
  2006-06-27 05:16:28  jewel_plat [Reply | View]
  
  
  could u please explain me how does the 2nd code works.
• how do we find nth highest in SQL
  2006-09-05 03:32:25  kunalpawar [Reply | View]
  
  
  this is the shortest and easiest way i fill to found nth higest....
  select min(e.salary) from
  (select salary from employees order by salary desc) e
  where rownum <= n;