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 / ramavtar rajput

select Amount from T2 where Amount = ( select max(Amount)
from T2 where Amount < ( select max(Amount) from T2 ))

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain strong name in .net assembly?

924


What are the difference between dispose(), close(), exit(), end()? When do we use them?

981


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

990


How to store images in sql server database through vb.net?

870


What do you mean by option strict on?

1070


Is vb net a scripting language?

916


Explain redim keyword?

958


Explain some of the exclusive features which are present in vb?

864


What are the difference between structure and class?

1063


Explain about branching logic control in vb.net?

890


What is internal keyword in .net framework?

989


What is tracing?

1045


How many ways the function can return values?

952


Explain what observations between vb.net and vc#.net?

898


write a program to develop a graphic user interface application of marks book with students names and their names.the program should show the following options main menu,add student details,display student details,maximum mark and minimum mark.

1566