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
147744 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

Describe varray?

1007

What is a sub query? What are its various types?

1082

What is bulk collect in oracle?

958

How to create lov dynamically at runtime & attach to text field?

1099

What is the use of aggregate functions in oracle?

981

What is the meaning of recursive hints in oracle?

995

Why packages are used in oracle?

1002

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.

1946

How to change program global area (pga) in oracle?

1034

What is oracle in java?

913

What happens if recursive calls get out of control?

1000

How do I find my oracle client driver version?

973

How to write date and time literals in oracle?

949

What are the limitations oracle database 10g xe?

979

How do I call oracle stored procedures that take no parameters?

1025