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

How to do clean up if create database failed?

1039

How to create a table in a specific tablespace?

985

How to change system global area (sga) in oracle?

1026

How to check your oracle database 10g xe installation?

998

What is SQL Tuning Advisor in Oracle?

1188

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2190

How can we force the database to use the user specified rollback segment?

1155

How to start a specific oracle instance?

1044

Is it possible to split the print reviewer into more than one region ?

2285

What is a proxy class?

1063

How to assign query results to variables?

1061

When do I need to use a semicolon vs a slash in oracle sql?

1098

What is blob datatype?

1135

What is instant client oracle?

1032

How to call a stored function in oracle?

1028