Hi, you can use following query. select ename,sal from(select ename,sal

How to get employee name from employee table which is the
fiveth highest salary of the table

Question Posted / ashwin

Answer Posted / ashwin

Hi, you can use following query.

select ename,sal from(select ename,sal from emp order by sal
desc)where rownum=5;

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is sql*loader?

1076

Explain how exception handling is done in advance pl/sql?

958

How long will it take to learn pl sql?

892

What are the possible values for the boolean data field?

902

What are types of joins?

910

How do I copy a table in sql?

931

What is not equal in sql?

1011

Does sql between include endpoints?

955

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

927

What is online transaction processing (oltp)?

962

Where is pl sql used?

905

Do foreign keys improve performance?

968

How does stored procedure reduce network traffic?

968

What is break?

1141

When is the update_statistics command used?

1049