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 / chandru teamwork

Oredrs is table name orderid is collum name


select top 1 * from Orders
where orderid <=(select max(OrderID) from Orders)

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What languages does the .net framework support?

926


What is difference between import system.data.sqlclient,system.data.oledb?

966


Explain namespace?

1018


Can you please explain the difference between dispose and finalize()?

949


What is the difference between manifest and metadata?

976


What are the difference between structure and class?

1066


How can I extract the formated word(bold,italic,underline,font,color etc) from the msword file.?

968


What are the assembly entry points?

965


What is the source code for display the picture in button click event?

1098


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

992


Explain convert.tostrin?

986


What are the different types of Lock available in Visual Basic?

1051


Can you please explain the difference between authentication and authorization?

978


Write a program to find all text files in a logical drive and return the count of the number of files?

2662


What is public assembly?

931