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

What is transport network substrate (tns) in oracle?

1092

Where do we use decode and case statements?

1061

what is the difference between functional dependecy and multilevel dependency?

2519

What are the oracle built-in data types?

1135

Can we write dml statement in function in oracle?

1125

Explain index?

1307

What is a relational database management system?

1171

Give the various exception types.

1040

How to execute a stored program unit?

1128

How to generate query output in html format?

1211

Is oracle the best database?

1010

How to run create database statement again?

1219

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2600

what are bitmap indexes? How does they work?

2303

Explain coalesce function?

1250