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...

sql satement for 2nd maximum value

Answer Posted / sanjeev singla

Hey guys use this query ,i used it so many time ,it will be
useful to you..try this one...

SELECT MAX(Salary) AS Expr1
FROM Employees
WHERE (Salary <
(SELECT MAX(Salary)
FROM Employees))

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about delegate?

850


Explain cts?

914


What is the significance of delegates?

901


Name some of the keywords used in vb.net?

975


What is a static variable?

1683


what is difference between namespace and assembly?

1039


What are the technology areas that microsoft.net contains?

967


Explain about the performance of visual basic?

989


Explain convert.tostrin?

998


What is static member?

981


What is the difference between manifest and metadata?

991


Explain how to store decimal data in .net?

1142


Explain trace in vb.net?

929


What are all the differences between dispose and finalize()?

1015


What is the differences between dataset.clone and dataset.copy?

1064