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

What is PL/SQL ?

1115

How to revoke create session privilege from a user in oracle?

559

What are the different types of trigger and explain its various uses and functions?

551

How translate command is different from replace?

550

if you ctreate table identity

1847

How to list all indexes in your schema?

584

Why oracle is used?

581

What is materialized view in Oracle?

631

What is a procedure in oracle?

618

Explain the difference between sap and oracle?

575

How to update a table row with a record?

597

Can we connect to ORACLE db using Windows Authentication?

722

How to calculate date and time differences in oracle?

535

Explain what are the advantages of views?

613

How to enter a new row into a table interactively?

550