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

In a distributed database system, can we execute two queries simultaneously?

1156

What is raid? How does it help storage of databases?

1133

What is clustered and nonclustered index in sql?

987

what are wild cards used in database for pattern matching ? : Sql dba

1207

What is an intersect?

1156

How do I view a view in sql?

996

what are date and time intervals? : Sql dba

1105

How does postgresql compare to mysql?

1080

How do I run pl sql in sql developer?

1176

Can I learn sql in a week?

1122

Is keyword pl sql?

1057

Does google use sql?

1008

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1019

What are the two types of exceptions.

1222

What version is sql?

1077