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

how to get second highest sal of emp table

Question Posted / manjeet

Answer Posted / manjeet

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to get execution statistics reports on query statements?

1094

How to add a new column to an existing table in oracle?

1139

How do I learn what codesets are available in oracle?

1038

What is a table index?

1098

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2043

What privilege is needed for a user to delete rows from tables in another schema?

1067

What is merge statement used for?

1024

Does facebook use oracle?

1031

Explain what are the characteristics of data files?

1085

Which is better Oracle or MS SQL? Why?

6386

why dont we assign not null constraint as table level constraint.

2738

material view and view disadvantages?

1073

How do I recompile a procedure in oracle?

964

Explain the use of grant option in exp command.

1063

How a tablespace is related to data files?

1109