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

find out the third highest salary?

Question Posted / ravindra

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

Please Help Members By Posting Answers For Below Questions

master table and child table performances and comparisons in Oracle ?

2136

What is a system tablespace?

1069

What to do if dba lost the system password?

1168

How do we represent comments in oracle?

1046

What is hash cluster in oracle?

1171

How do I know if oracle client is installed on windows?

1022

What is oracle latest version?

1094

How to store pictures on to the database?

973

How to load a large xml file?

1055

What is oracle rownum?

950

What is the data type of dual table?

991

What is a sub query and what are the different types of subqueries?

1123

Is rowid unique in oracle?

998

What is sequence?

1078

What is ordinary table in oracle?

1154