How to retrieve 5th highest sal from emp table?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a system tablespace?

598


What is the difference between a hot backup and a cold backup in oracle?

573


What is proxy method?

542


What is oracle rownum?

517


How to commit the current transaction in oracle?

576






Explain temporal data types in oracle

607


What are the uses of synonyms?

603


How to change program global area (pga) in oracle?

584


Can a formula column be obtained through a select statement ?

1845


Explain the use of parfile option in exp command.

526


State any two functions of oracle?

634


What is a cognitive schema?

527


Is oracle a programming language?

564


Differentiate between post-database commit and post-form commit?

543


How to update a table row with a record?

597