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 / archana chavan

select top 1 * from author where phone < (select max(phone)
from author) order by phone desc

Is This Answer Correct ?    18 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of system.diagnostics.process class?

1066


What is the Advantage of vb.net over vb

1005


What is the significance of delegates?

966


How do you define a read only property in a class module?

947


What is stack used for in vb. Net?

951


Explain the difference between vb.net and c#, related to oops concepts?

939


Describe about visual basic.net?

1002


What languages does the .net framework support?

998


Explain the difference between .dll extension and .exe extension files?

1066


What is the feature anonymous type?

932


Define cls?

1022


Is vb net a scripting language?

976


Name some of the features present in vb 2005?

960


Can you please explain the difference between namespace and assembly?

1056


What is redim keyword?

1005