select * from (select sal from emp order by desc) emp where rownum = 5

write a query for the fifth highest salary?

Question Posted / aravind

Answer Posted / aravind

select * from (select sal from emp order by desc) emp where
rownum = 5

Is This Answer Correct ?

6 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What is the advantage of varchar2 over char?

786

Explain buffer manager?

550

Explain entity type?

623

What are the types of indexes that are present inside a database?

628

What is the difference between oracle and MS Access?

608

What is the best database software for small businesses?

497

Should I store images in database?

568

What are the tools used for backup and ticketing?

570

How to shrink a database?

539

How many indexes can be created on a table?

609

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

582

Differentiate between extension & intension?

850

Is redis in memory database?

530

What is the best database?

517

Data structure used to implements a menu:

622