advertisement

Article:
  SQL Data Types
Subject:   how do we find nth highest in SQL
Date:   2006-09-05 03:32:25
From:   kunalpawar
Response to: how do we find nth highest in SQL

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;