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 to fetch common records from two tables? : Sql dba

1187

how to escape special characters in sql statements? : Sql dba

1048

What is full join in sql?

1003

What is procedure explain with program?

1029

What are the different types of joins in sql?

1816

What is the use of sqlerrd 3?

950

How do you drop a trigger?

999

What is rename command in sql?

1045

Mention what does the hierarchical profiler does?

1103

What are all types of user defined functions?

1087

What is a scalar value in sql?

1086

What is bind reference and how can it be created?

1026

Can we use pl sql in sql server?

1093

What are all the different types of indexes?

1159

What are all different types of collation sensitivity?

1044