||SQL Data Types|
|Subject:||how do we find nth highest in SQL|
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;