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

find out the third highest salary?

Question Posted / joel

92 Answers
151185 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answer Posted / joel

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

Is This Answer Correct ?

6 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to convert characters to numbers in oracle?

1065

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1384

How to establish administrator authentication to the server?

1043

How to experiment a data lock in oracle?

1056

How to commit the current transaction in oracle?

1120

How to define an anonymous block?

1157

How to write a left outer join with the where clause in oracle?

1084

Is truncate autocommit in oracle?

1087

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007

What is query image?

981

Can we create database in oracle using command line ?

1088

Can we write insert statement in function in oracle?

1092

How can I create database in oracle?

1026

How to load a large xml file?

1055

What is the recommended interval at which to run statspack snapshots, and why?

2920