select sal from employee where sal >= (select max(sal) from employee wh

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

Question Posted / naveen

Answer Posted / naveen

select sal from employee where sal >= (select max(sal) from
employee where sal not in (select max(sal) from employee))

Is This Answer Correct ?

7 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What are the differences between char and nchar in oracle?

1021

What is the disadvantage of User defind function?

2238

How to use subqueries with the exists operator in oracle?

968

List out the components of logical database structure of oracle database.

984

How do I start tns listener?

988

Can group functions be mixed with non-group selection fields?

955

What happens in oracle commit?

970

How do I find the database name in oracle?

979

What is a system tablespace?

1004

What is the data pump import utility?

968

What is PL/SQL ?

1902

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5330

State the various uses of dbcc command?

989

How to concatenate two text values in oracle?

1052

How to return top 5 rows in oracle?

987