Select Max(sal) from emp where sal < any (select sal from emp);

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

Question Posted / shashank yadav

Answer Posted / shashank yadav

Select Max(sal) from emp
where sal < any (select sal from emp);

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How a database is related to tablespaces?

982

How to start instance with a minimal initialization parameter file?

989

Why oracle is used?

994

Explain view?

977

Define oracle database

991

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1825

How many data types are supported?

1021

How to define an oracle sub procedure?

1054

What is save point in oracle database?

1238

What are oracle functions?

973

Is a rollback possible to any savepoint?

997

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2299

What is connection pool in oracle?

926

How will you identify oracle database software release?

941

What is the simplest tool to run commands on oracle servers?

954