select min(a.sal) from (select distinct(d.sal) from emp order by d.sal de

How to retrieve 5th highest sal from emp table?

Question Posted / amit bhagat

Answer Posted / amit bhagat

select min(a.sal) from (select distinct(d.sal) from emp
order by d.sal desc) a where rownum<=5

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is catalog in Oracle?

1371

What is translate in oracle?

1100

What is a data lock in oracle?

1133

What is the fastest query method to fetch data from the table?

1368

What is an oracle database table?

1017

Who developed oracle & when?

1008

What are the different pseudo commands? Explain in general?

1080

Explain a data segment?

1073

How can we view last record added to a table?

1040

List out the difference between commit, rollback, and savepoint?

1038

what is dynamic SGA and static SGA

4421

What are the uses of a database trigger?

994

How do I limit the number of rows returned by an oracle query after ordering?

1172

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2215

How to lock and unlock a user account in oracle?

1108