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

Can a view be mutating? If yes, then how?

753

What is keys and its types?

749

how to present a past time in hours, minutes and seconds? : Sql dba

739

Why do we need cursor in pl sql?

832

What is oracle sql developer?

788

Explain the purpose of %type and %rowtype data types?

663

How can you fetch common records from two tables?

774

what are the features and advantages of object-oriented programming? : Sql dba

727

What is difference between mysql and postgresql?

705

What are different types of statements supported by sql?

820

How do I run a pl sql program?

802

What is an index in sql with example?

710

what is query cache in mysql? : Sql dba

762

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

751

Inline the values in PL/SQL, what does it mean.?

854