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

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

1303

How to convert characters to dates in oracle?

1103

What language does oracle use?

1107

What is the difference between sharding and replication?

1055

Why do we use coalesce function in oracle?

1124

How can I combine multiple rows into a comma-delimited list in oracle?

1062

How to rollback the current transaction in oracle?

1056

What are the uses of a database trigger?

994

Whether any commands are used for months calculation? If so, what are they?

1099

What is a cursor in oracle?

1176

What do you mean by group by clause?

1047

Difference between inner join vs where ?

1039

How to find out what oracle odbc drivers are installed?

1042

What is a parameter file in oracle?

1134

How to create a new table in oracle?

1159