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

Explain the use of rows option in exp command.

1080

What is a nvl function?

1013

How to loop through a cursor variable?

1078

Why should I use oracle database?

980

Explain the features of oracle?

1036

How to sort output in descending order in oracle?

1033

What is oracle latest version?

1090

What is a proxy object?

1052

Design database draw er diagram for a certain scenario ?

4575

How to use in conditions in oracle?

1045

What is the difference between substr & instr functions?

1216

What is oracle join syntax?

992

What is a table index?

1088

What are the uses of a database trigger?

987

Explain the use of grant option in exp command.

1054