Women in Technology

Hear us Roar


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.
Full Threads Oldest First

Showing messages 1 through 2 of 2.

  • how do we find nth highest in SQL
    2006-06-27 05:16:28  jewel_plat [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 [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;

Recommended for You
 
Sign up today to receive special discounts,
product alerts, and news from O'Reilly.
Privacy Policy >
View Sample Newsletter >