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

what are steps for interface? where is exchange rate defined in which table?

2121

Explain what are clusters?

1085

How to insert a record into a table?

1050

What are the numeric comparison operations?

1093

Explain joins in oracle?

1021

What is oracle server autotrace in oracle?

1140

what is normalisation?what are its uses?

2247

How to export your own schema?

994

What is oracle database 10g express edition?

1104

what is a Nested Loop join?

2086

What is sharded cluster?

992

How to start a specific oracle instance?

1014

What are set operators?

1059

How to count duplicated values in a column in oracle?

1022

What is a proxy object?

1042