Article:
  SQL Data Types
Subject:   how do we find nth highest in SQL
Date:   2006-06-27 05:16:28
From:   jewel_plat
Response to: how do we find nth highest in SQL

could u please explain me how does the 2nd code works.
Main Topics Oldest First

Showing messages 1 through 1 of 1.

  • 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;