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 / bhamidipati srinivas

Answer Posted / bhamidipati srinivas

select (select max(gross) from employee_dtls),(select max
(gross) as nextmaximum
from employee_dtls where gross<(select max(gross) from
employee_dtls)) from dual

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is archive log in Oracle?

1064

What is meant by joins? List out the types of joins.

953

Explain an exception?

918

What is blob data type in oracle?

1042

What is oracle open database communication (odbc)?

957

Explain compound trigger in oracle?

982

types of indexes and the rationale behind choosing a particular index for a situation.

2443

How to create a single index for multiple columns?

973

How do you bind variables in oracle?

927

How do I manually uninstall oracle client?

1019

In oracle there is column command, how will you explain that?

964

How to assign values to data fields in record variables?

970

Explain what are clusters?

1041

What is define in oracle?

998

What are the advantages of oracle?

960