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

What is the use of errorprovider control?

599


What is the difference between c# and vb.net?

566


What is the main purpose of garbage collector?

513


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

568


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

533






Name the class which allows an element to be accessed using unique key?

574


Before in my vb app I would just load the icons from dll. How can I load the icons provided by .net dynamically?

526


Which dll is used for microsoft .net run time?

557


How many languages are supported by .net?

557


Explain public assembly?

561


What are the advantages of vb.net and c#?

645


What are the different types of applications supported in .net (or) .net framework?

517


how to get dynamic control array position or its index position?

2055


How do you use two datareaders at the same time in a vb.net windows application ?

564


what is difference between web.config and machine.config and where it will be ?

492