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 difference between delete and truncate commands? : Sql dba

539

How does one use sql*loader to load images, sound clips and documents? : aql loader

674

What are sql procedures?

582

how to analyze tables with 'mysqlcheck'? : Sql dba

547

Explain the components of sql?

589

How do you clear the screen in sql?

601

What are aggregate functions in sql?

629

Explain two easy sql optimizations.

604

How do you sort in sql?

603

Can we use distinct and group by together?

588

How can I change database name in sql?

531

How subquery works in sql?

543

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

558

Which language is used in sql?

518

Why do we need view in sql?

549