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

Explain about the performance of visual basic?

981


What is difference between metadata and manifest?

1034


What is the significance of delegates?

888


Write a VB.Net console program to check whether a number is perfect or not.

7700


What is the use of assembly?

939


Can you please explain the difference between authentication and authorization?

978


What is global assembly cache (gac)?

952


What are the parts of the visual basic control?

893


Explain the advantages of vb.net?

899


What is DLL HELL in VB.NET

988


How to send xml file on server using http protocol?

941


Explain the advantage of option strict on?

878


What is the difference between Namespace and Assembly?

1050


What is a stream in vb.net?

925


Explain about rapid application development tool?

902