select top 1 salary from (select top 1 salary from employee order by s

find out the third highest salary?

Question Posted / paridhi

Answer Posted / paridhi

select top 1 salary from
(select top 1 salary from employee order by
salary desc) a
order by salary

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2291

How to retrieve values from data fields in record variables?

1036

What is an oracle and why it is used?

1080

How to retrieve data from an explicit cursor?

1009

Oracle

2321

How to turn on or off recycle bin for the instance?

1012

Hi Can any one tell me what are the API's used in requisition import.

1881

Give the various rollback segment states.

1000

Explain what are clusters?

1042

What's dateware house and what's clustor with practicle example

2128

defination of bitmap index

2047

How do I know if oracle is installed on windows?

881

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

978

What is the difference between a primary key & a unique key?

1042

How to delete a column in an existing table?

1020