Ajay

• Mar 24th, 2005

 

select sal from emp e where n-1=(select count(distinct sal) from emp where sal>e.sal);

AjayLebaka

• Mar 26th, 2005

 

select sal from emp E 
wherenulln-1=(select count( distinct sal) from emp where  
sal>E.sal);

padma

• Mar 23rd, 2006

 

select max(sal) from (select distinct sal from emp where rownum<=(n+1) order by sal)

where n is the nth position.

rajanipriya

 Profile Answers by rajanipriya Questions by rajanipriya

• May 16th, 2006

 

Mr Ajay,

   Sir , i couldnot understand the query u wrote for nth highest salary.

   please explain in detail!!!!

Shiv Mangal Rahi

• Jul 24th, 2006

 

Hi,

Try this one.I hope u could able to get it

SQL> select min(sal) from (select sal from emp order by sal desc)
 where rownum<n+1;

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

 

select * from emp where rownum<=9

minus

select * from emp where rownum <9

sudhaker

 Profile Answers by sudhaker 

• Dec 27th, 2006

 

select min(sal) from (select distinct(sal) from emp order by sal desc) where rownum<='&n';

Sangeeta

• Jun 1st, 2007

 

this is the best solution to find out nth highest solution : select min(sal) from emp where sal in (select sal from (select sal from emp order by sal desc) where rownum <=&n )

soorajsk_84

 Profile Answers by soorajsk_84 Questions by soorajsk_84

• Sep 20th, 2007

 

SELECT ename,sal FROM emp s

WHERE (n-1)=

(SELECT count(*) FROM emp e

WHERE e.sal>s.sal)

This will return you the right result

G.D.S.Prasad

 Profile Answers by G.D.S.Prasad Questions by G.D.S.Prasad

• Jun 21st, 2008

 

 Select min(sal) from (Select rownum,ename,sal from (Select * from emp order by sal desc)  where rownum<n+1);

sunjer

 Profile Answers by sunjer 

• Jul 27th, 2008

 

Here you go...

 select *
 from (select sal from emp order by 1 desc)
 where rownum < 5;

chirla_pavan

 Profile Answers by chirla_pavan 

• Sep 12th, 2008

 

select * from employee where 1=(select count(*) from employee as e where employee.sal<e.sal)

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 2nd, 2010

 

SELECT ename, sal FROM (select ename,sal,dense_rank() OVER (order by sal desc) dr FROM emp) WHERE dr =n;