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

Explain the use of file option in exp command.

595

Explain parameter file in oracle.

574

How to define a specific record type?

616

What is a system tablespace and when it is created?

556

Write a syntax for update query in oracle?

614

How will you differentiate between varchar & varchar2?

587

How to invoke the data pump export utility?

555

How to retrieve the count of updated rows?

570

How to create a single index for multiple columns?

558

does the query needs a hint to access a materialized view?

1462

How to create an oracle database manually?

568

How to check the server version in oracle?

608

How to download oracle database 10g xe?

595

Whether any commands are used for months calculation? If so, what are they?

592

What is the difference between Delete, Truncate and Drop in Oracle?

602