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 coalesce function?

1146

How do I find my oracle client driver version?

1095

Explain the use of full option in exp command.

1175

What is a server parameter file in oracle?

1097

How to work with data objects interactively?

1043

What is oracle database 10g express edition?

1169

What is connection pool in oracle?

1037

How to select some rows from a table in oracle?

1127

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3246

Describe the types of sub query?

1057

Which are the five query types available in oracle?

1000

Which environment variables are absolutely critical in order to run the OUI?

2173

Explain what are the type of synonyms?

1185

What is a sub query? Describe its types?

1072

How do I uninstall oracle 11g?

1177