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 call a sub procedure?

1095

Please explain oracle left join with an example?

1048

What is the usage of analyze command in oracle?

1094

How to connect to a remote server?

1127

What is a partition in oracle?

1122

Explain the use of rows option in exp command.

1093

How to rollback the current transaction in oracle?

1055

How a database is related to tablespaces?

1032

How to use select statement to count the number of rows in oracle?

1046

What do you mean by a deadlock?

1065

Can multiple cursors being opened at the same time?

1060

How to synchronize 2 schema's objects?

2181

Does oracle charge for java?

1058

Can we connect to ORACLE db using Windows Authentication?

1257

What is oracle thin client?

1024