select distinct * from (select e.*,dense_rank()over(order by sal desc) rn

How to find 1st, 2nd, 3rd highest using select select
statement not using rownum

Question Posted / ajit

Answer Posted / ajit

select distinct *
from (select e.*,dense_rank()over(order by sal desc) rn from emp e)
where rn in (1,2,3);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I know if oracle is installed on windows?

876

How to connect the oracle server as sysdba?

1008

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2329

what is reindexing?

1608

How to do a full database export?

1042

What is Library Cache in Oracle?

1073

What is the max number of columns in an oracle table?

928

How to connect asp pages to oracle servers?

1002

What is parameterized cursor in oracle?

1064

What is the use of oracle?

980

How to rebuild an index in oracle?

968

What is the sql query to concatenate column values from multiple rows in oracle?

995

Can the query output be sorted by multiple columns in oracle?

933

What is oracle join syntax?

940

How to start instance with a minimal initialization parameter file?

989