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 many types of synonyms in Oracle?

1066

What is the max number of columns in an oracle table?

932

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1015

What is raw datatype in oracle?

1052

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2259

What is the scope of a local variable?

998

How to convert character types to numeric types?

1056

What to do if the binary spfile is wrong for the default instance?

999

What are the database administrators utilities available?

972

what are archived logs?

2144

what is a Nested Loop join?

2041

What is rich query?

929

How to put more than 1000 values into an oracle in clause?

974

How to store pictures on to the database?

924

What is where clause in oracle?

982