SELECT MAX(SAL) FROM EMPLOY WHERE SAL < ( SELECT MAX(SAL) FROM EMPLO

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

Question Posted / raghav

Answer Posted / raghav

SELECT MAX(SAL)
FROM EMPLOY
WHERE SAL < ( SELECT MAX(SAL) FROM EMPLOY )

Is This Answer Correct ?

5 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Can we save images in a database and if yes, how?

1057

Explain the difference between a procedure and a function? What do you understand by those terms?

1071

What is tns name?

975

What is the order of defining local variables and sub procedures/functions?

1054

What is flashback in Oracle?

1014

What is snapshot is too old? Give and example for better understand.

1599

what is the use of system.effective.date variable in oracle?

1105

How to select some columns from a table in oracle?

1078

Explain the use of ignore option in imp command.

1028

What is the usage of synonyms?

1134

what is port in oracle? how is it related to database application.

1941

How to define and use table alias names in oracle?

933

How will you write a query to get a 5th rank student from a table student_report?

1857

How to write date and time literals in oracle?

996

Explain oracle left join with an example?

1003