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

How remove data files before opening a database?

1033

What is a nvl function?

980

How to establish administrator authentication to the server?

1008

How to call a stored function with parameters?

990

Please explain joins in oracle?

1027

Explain the use of show option in imp command.

1064

What do you mean by merge in oracle?

959

How to load data from external tables to regular tables?

1024

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

987

What are the general rules on data consistency?

978

How to convert a string to a date in oracle database?

1013

How to define a variable of a specific record type?

1035

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1611

What is control file used for?

1138

Difference between open_form and call_form in oracle.

1112