Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is port in oracle? how is it related to database application.

1991

What is a table index?

1168

How to select an oracle system id (sid)?

1122

What is a private synonym?

1644

What is Trigger in Oracle?

1241

What are the most common interview questions on ETL Testing for experience?

1189

What is oracle rownum?

1016

What is clustered table in Oracle?

1261

How to use fetch statement in a loop?

1067

What is Library Cache in Oracle?

1187

How to lock and unlock a user account in oracle?

1161

How data locks are respected in oracle?

1110

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2363

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2234

Are truncate and delete commands same? If so why?

1202