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

find out the second highest salary?

Question Posted / prasant

Answer Posted / prasant

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

MAX(SAL)
----------
3000

Is This Answer Correct ?

22 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to update values on multiple rows in oracle?

1034

What is the maximum limit on the number of columns in a table?

1086

What is procedure overloading in oracle?

1061

please explain.. DB architecture ...

2020

Can we connect to ORACLE db using Windows Authentication?

1257

What's dateware house and what's clustor with practicle example

2175

How many types of synonyms in Oracle?

1124

How to write an inner join with the where clause in oracle?

1044

How to create a stored program unit?

1228

What is the max number of columns in an oracle table?

999

Explain about integrity constraint?

1122

Can you create a synonym without having a table?

1042

When do you get a .pll extension in oracle?

1146

What is raw datatype?

1136

How do I connect to oracle?

1030