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

query optmization techniques and quwry analyser+projects+ppts

2425

What is the quickest way to export a table to a flat file?

969

List out the difference between commit, rollback, and savepoint?

1039

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1049

Explain an index segment?

1124

What is the difference between postgresql and oracle?

1055

How can we force the database to use the user specified rollback segment?

1152

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

2361

What is the difference between a hot backup and a cold backup in oracle?

1021

How to sort the query output in oracle?

1029

What is an oracle table?

993

How to create tables for odbc connection testing?

1124

Please explain oracle data types with examples?

1075

What do you understand by database schema and what does it hold?

1233

Explain about integrity constraint?

1132