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

find out the third highest salary?

Question Posted / ravindra

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

Answer Posted / ravindra

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a tns file?

941

What is oracle server autotrace in oracle?

1091

How to retrieve values from data fields in record variables?

1036

How to rename an existing table?

1052

How to bring a tablespace offline?

1001

How to set up autotrace for a user account?

976

What is difference between truncate and delete?

977

What are oracle functions?

976

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2320

what is difference between sql plus and sql*plus? (not sql and sql plus).

3814

How to check the server version in oracle?

1035

What are the extensions used by oracle reports?

998

How to use subqueries with the exists operator in oracle?

972

How to export several tables together?

990

Explain oracle’s system global area (sga).

1076