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

What is an oracle and why it is used?

628

What are the set operators union, union all, minus & intersect meant to do?

569

how the indexes are stored in the Oracle Database?

1745

How to set a transaction to be read only in oracle?

589

Explain the use of parfile option in exp command.

529

Explain a data segment?

655

How do I spool in oracle?

546

What is the database name in oracle?

538

How to execute the package in oracle?

577

How do I limit the number of rows returned by an oracle query after ordering?

642

What is the data type of dual table?

533

What are the advantages of oracle?

555

What privilege is needed for a user to create views in oracle?

596

what happened to the global index when I truncate the data in one of the partition?

1526

Difference between pre-select and pre-query

579