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 the difference between data migration and production migration.

2272

How to recover a dropped table in oracle?

983

Describe the types of sub query?

938

What are the ansi data types supported in oracle?

893

How to shutdown your 10g xe server from command line?

1013

What privilege is needed for a user to query tables in another schema?

917

what is the difference between restoring and recovering?

961

How would you go about verifying the network name that the local_listener is currently using?

1989

What is hot backup and logical backup?

998

Explain an extent?

1047

What are the different editions of oracle?

1045

How would you change old and new values in an insert, delete and update triggers?

950

What happens to the current transaction if the session is killed?

924

Difference between pre-select and pre-query

1027

Difference between varchar and varchar2 data types?

1114