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.

Showing messages 1 through 1 of 1.

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