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

3 Answers
6181 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2178

How to convert times to characters in oracle?

1071

What is catalog in Oracle?

1437

How to use in conditions in oracle?

1115

How to convert csv to table in oracle?

1044

What is the string concatenation operator in oracle?

1230

Explain about the analyze command in oracle?

1112

When do you get a .pll extension in oracle?

1191

What is archive log in Oracle?

1182

When do you get a .pll extension in oracle? Explain its importance

1098

How to select some columns from a table in oracle?

1171

What are the advantages of oracle 12c?

1234

How to connect to a remote server?

1188

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2191

What are the various types of snapshots ?

1082