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

Query to get max and second max in oracle in one query ?

Question Posted / mehul

Answer Posted / mehul

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

Is This Answer Correct ?

29 Yes

12 No

Please Help Members By Posting Answers For Below Questions

List the types of joins used in writing subqueries?

955

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1906

How to grant create session privilege to a user in oracle?

958

Explain oracle data types with examples?

976

Explain implicit cursor.

971

Why use resource manager in Oracle?

1069

How to synchronize 2 schema's objects?

2130

Is there a combination of "like" and "in" in sql?

1023

Explain integrity constraint?

1126

Explain the use of constraints option in exp command.

1007

How to use like conditions in oracle?

1008

Explain about the analyze command in oracle?

1012

How to view the data files in the current database?

1054

What are the differences between blob and clob in oracle?

1046

Why cursor variables are easier to use than cursors?

1037