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

Use of an integrity constraint is better to validate data. Explain

1023

What is index-organized table in Oracle?

1055

What is bulk collect in oracle?

986

Explain the different normalization forms?

1058

What is tns name?

964

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1862

How to get maxsal , minsal, ename department wise in single query

1536

What is save point in oracle database?

1284

how can we store any pdf file in oracle

2151

what is IDE,DMV in sql server?

2802

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1988

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

993

How many types of auditing in Oracle?

1020

How to see the table columns used in an index?

1007

How to rename a tablespace in oracle?

1073