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

Explain the types of exception?

1139

What is data file?

1097

Name the three major set of files on disk that compose a database in Oracle?

1118

What is a snapshot log?

998

What is a lookup table in oracle?

968

How to create a table index in oracle?

1127

What do you know about normalization? Explain in detail?

942

How to connect the oracle server as sysdba?

1072

What is an oracle table?

981

what is dynamic SGA and static SGA

4408

What is Segment Advisor in Oracle?

1101

what is meant by magic query

2176

What is an oracle recycle bin?

1004

Can we connect to ORACLE db using Windows Authentication?

1240

Why do we need integrity constraints in a database?

1015