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
89903 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 do paging with oracle?

1004

What is index in Oracle?

1077

What is define in oracle?

1063

What are the different pseudo commands? Explain in general?

1081

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2341

What is oracle instant client?

1029

What are the limitations oracle database 10g xe?

1047

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2022

Does oracle charge for java?

1060

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2974

Explain the truncate in oracle?

971

In the oracle version 9.3.0.5.0, what does each number shows?

1305

Explain implicit cursor.

1037

What is a Garbage Collection? and what is full recursive Garbage collection?

2907

Explain about integrity constraint?

1132