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 to create a table index?

1095

What is data block in Oracle?

1070

What do you mean by merge in oracle?

959

What is a subquery?

1076

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1953

What is Segment Advisor in Oracle?

1073

What is connection pooling in oracle?

935

Where do we use decode and case statements?

970

How to manage transaction isolation level?

965

How to set a transaction to be read only in oracle?

1062

What is meant by recursive hints in oracle?

1055

How to use attributes of the implicit cursor in oracle?

969

What are the different pseudo commands? Explain in general?

1045

State some uses of redo log files?

965

How to use fetch statement in a loop?

996