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

find out the second highest salary?

Question Posted / hiten

55 Answers
75882 Views
Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create a temporary table in oracle?

681

Explain the use of parfile option in exp command.

511

What is a cursor in oracle?

636

What are the differences between date and timestamp in oracle?

545

Can we call procedure inside function in oracle?

597

What is an oracle tablespace?

594

can u plz provide me oca sql dumps please i need them

1458

How to create an oracle database manually?

559

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

920

How do we create privileges in oracle?

576

How to create a server parameter file?

565

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

4657

What are the common oracle dba tasks?

616

What are the differences between blob and clob in oracle?

571

How many data types are supported?

608