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 the process of debugging?

1070

Does user triggers have entry for trigger with compilation errors?

1035

how does a local variable is defined using t-sql? : Transact sql

1018

Why use stored procedures?

1094

What is t-sql? : Transact sql

988

What is nosql vs sql?

1179

Does view contain data?

1037

What is %type in pl sql?

968

How do you sort in sql?

1027

What is query syntax?

973

Does inner join remove duplicates?

943

What are views in sql?

989

What is right join in sql?

1092

what is commit? : Sql dba

1078

Which are the different character-manipulation functions in sql?

1065