select rownum,name,salary from (select name,salary from employee

How to retrieve 5th highest sal from emp table?

Question Posted / arvind patil

Answer Posted / arvind patil

select rownum,name,salary
from (select name,salary
from employee
order by salary desc )
where rownum=5;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between a procedure and a function?

1143

How to define a data source name (dsn) in odbc manager?

1009

When do you get a .pll extension in oracle? Explain its importance

1016

How to use "if" statements on multiple conditions?

1143

How to drop an existing view in oracle?

933

Please explain compound trigger in oracle?

1038

What is the use of oracle?

1019

How to get execution statistics reports on query statements?

1064

Explain what are the characteristics of data files?

1064

What is the difference between $oracle_base and $oracle_home?

1070

Why we use bulk collect in oracle?

1013

How to rename an existing table?

1103

Does oracle partitioning improve performance?

968

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1047

What are the limitations oracle database 10g xe?

1021