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 is a Garbage Collection? and what is full recursive Garbage collection?

2902

what is the difference between data migration and production migration.

2346

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

How to load data from external tables to regular tables?

1062

Write a trigger example in oracle?

1063

How can I create database in oracle?

1026

What is a system tablespace?

1072

How do I uninstall oracle 11g?

1118

Explain enable novalidate constraint.

1081

How to load data through external tables?

1135

What is parameterized cursor in oracle?

1150

How to grant create session privilege to a user in oracle?

1001

What do you mean by merge in oracle and how can you merge two tables?

948

What is rowid and rownum in oracle?

1011

What is tns service name?

1126