select max(sal) from emp where sal <(select max(sal)from emp where sal&

find out the third highest salary?

Question Posted / neha

Answer Posted / neha

select max(sal) from emp where sal <(select max(sal)from emp
where sal<(select max(sal) from emp));

Is This Answer Correct ?

103 Yes

31 No

Please Help Members By Posting Answers For Below Questions

What do database buffers contain?

958

How many data types are supported?

1022

How to create a new table in oracle?

1065

Briefly explain what is literal? Give an example where it can be used?

973

What are the various oracle database objects?

1091

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2212

How to display employee records who gets more salary than the average salary in the department?

998

Explain temporal data types in oracle

1040

What is a table index in oracle?

1067

Please explain oracle data types with examples?

990

How to invoke the data pump import utility?

1080

11. Display the client number and name and the client number and name of the person who referred that client.

2274

Give the various exception types.

943

What is query image?

922

What is a system tablespace and when it is created?

918