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 many types of auditing in Oracle?

1086

How to change system global area (sga) in oracle?

1066

what are archived logs?

2260

What is control file used for?

1302

Why do you use stored procedures and state some of its disadvantages?

1072

What is the string concatenation operator in oracle?

1231

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2409

Are truncate and delete commands same? If so why?

1202

What is proxy method?

1022

Difference between oracle's plus (+) notation and ansi join notation?

1160

What do you mean by merge in oracle and how can you merge two tables?

1007

What are the original export and import utilities?

1259

How to add another datafile to a tablespace?

1088

How is it different from a normal table?

1084

what is the difference between substr and instr function in oracle?

1143