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 the difference between alert log file and tarce file ?

1627

What is an external table?

581

What is literal?

579

How does the on-delete-cascade statement work?

600

What is an oracle data file?

603

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

541

What is the difference between pre-select and pre-query?

613

How to bring a tablespace online?

510

How to get the Installed Oracle Version Information ?

612

How to convert times to characters in oracle?

596

Explain integrity constraint?

636

How to drop a tablespace?

559

Explain view?

571

What is the data pump export utility?

633

What happens to the data files if a tablespace is dropped?

565