var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: finding the nth highest salary
please send me the querry for
'selecting the nth highest salary'
from a table containg details of
employees in an organisation where rows are not
entered in acending or descending order of
i am using oracle 8.0.6
Last edited by binoy_jd; 12-23-03 at 00:50.
You can use function rank() as in eg below:
For nth highest salary:
select emp, sal from
(select emp, sal, rank() over (order by sal desc) rankSal from emp)
where rankSal = n;
Oracle can do wonders !