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 a view and how is it different from a table?

1056

What are the different types of record groups in oracle? Explain each of them

1028

How to shutdown your 10g xe server from command line?

1092

What is the data type of dual table?

997

Explain the different normalization forms?

1111

How to use attributes of the implicit cursor in oracle?

1012

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3207

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1866

What is a directory object?

1101

How to build data dictionary view an new database?

1015

How many categories of data types in oracle?

1032

Explain self joins in oracle?

1025

What are the uses of synonyms?

1138

Â How to use an oracle sequence generator in a mapping?

1078

How to insert multiple rows with one insert statement in oracle?

1093