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 is bind variable in oracle 11g?

1041

How to fetch the row which has the max value for a column?

1004

How to create a table in a specific tablespace?

982

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2234

What are the general rules on data consistency?

1016

What is a nested table and how is it different from a normal table?

1062

What is analyze command used for?

1081

What is the difference between PFILE and SPFILE in Oracle?

1069

How to create a stored procedure in oracle?

1110

What is a package ? What are the advantages of package ?

1093

Difference between hot backup vs. Cold backup?

1002

Explain overloading. Can functions be overloaded?

1006

What are the different types of failures that occur in Oracle database?

1072

What is an oracle transaction?

1156

What is a trigger and what are its types in oracle?

1083