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

How do I tune a sql query?

973

What are the types of optimization?

955

How can we optimize a sql query?

1047

what are all types of user defined functions? : Sql dba

1042

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1127

How show all rows in sql?

1011

Mention what does the hierarchical profiler does?

1088

What is an emotional trigger?

1003

What are packages in pl sql and also explain its advantages?

1033

What are the benefits of stored procedures?

1060

What is the use of partition by in sql?

992

Is record in pl sql?

966

Explain correlated query work?

1047

Explain about various levels of constraint.

945

what is the difference between cluster and non cluster index? : Sql dba

1023