to find nth highest salary
select distinct (a.sal) from emp a where &n=select (count(distinct b.sal) from emp b where a.sal<=b.sal);
Type: Posts; User: purnimamca; Keyword(s):
to find nth highest salary
select distinct (a.sal) from emp a where &n=select (count(distinct b.sal) from emp b where a.sal<=b.sal);