SELECT Sal FROM (Select Sal from Emp_Salary order by Sal desc) WHERE r

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

Question Posted / vaibhav

34 Answers
64120 Views
CTS, Keane India Ltd, TCS, Wipro, I also Faced
E-Mail Answers

Answer Posted / vaibhav

SELECT Sal
FROM (Select Sal from Emp_Salary order by Sal desc)
WHERE rownum < =2;

Above query will fetch two rows. First row is the max salary
and second row second max.

IF we only need to find second max, then

SELECT Min(Sal)
FROM (Select Sal from Emp_Salary order by Sal desc)
WHERE rownum < =2;

Is This Answer Correct ?

4 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to drop an existing table in oracle?

1012

What is sharded cluster?

924

Where is the export dump file located?

1079

How does the on-delete-cascade statement work?

1058

How to save query output to a local file?

967

What is primefaces used for?

1005

What is an oracle database?

983

What is a trace file and how is it created in oracle?

970

How to call a sub procedure?

1034

What is an oracle database table?

958

How to invoke the data pump export utility?

1113

Explain temporal data types in oracle

1039

How to start instance with a minimal initialization parameter file?

989

What is index in Oracle?

1007

What is a parameter file in oracle?

1048