select max(sal) from emp where sal not in(select max(sal) from emp);

find out the second highest salary?

Question Posted / hiten

Answer Posted / hiten

select max(sal) from emp where sal not in(select max(sal)
from emp);

Is This Answer Correct ?

25 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to write an inner join with the where clause in oracle?

585

What is blob data type in oracle?

561

How to upsert (update or insert into a table)?

540

How to connect the oracle server as sysdba?

633

How to create an oracle testing table?

592

How to specify default values in insert statement using oracle?

566

What are the roles of dba?

614

What are privileges and grants?

572

What are the differences between char and varchar2 in oracle?

565

Why oracle is used?

581

Explain cascading triggers.

574

How to define an external table with a text file?

579

What are the differences between date and timestamp in oracle?

554

What is truncate oracle?

533

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

640