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

What happens to the data files if a tablespace is dropped?

1071

What is difference between cartesian join and cross join?

1103

How to create a new table by selecting rows from another table?

1109

What is an index associated with a constraint?

1044

How to check the oracle tns settings?

1053

What is a nested table?

1071

How to create lov dynamically at runtime & attach to text field?

1212

How to assign query results to variables?

1061

Explain the use of control file?

1120

Explain drop constraint oracle?

1080

What are the execution control statements in oracle?

1102

How to build data dictionary view an new database?

1018

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1748

Is oracle the best database?

973

What are the major difference between truncate and delete?

1070