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 internal keyword in .net framework?

640


How a base class method is hidden?

699


What is the difference between manifest and metadata?

631


Name some different types of control?

600


What is late binding and early binding?

636






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

653


What do you mean by option strict on?

742


List the different types of assembly?

622


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

7096


What is the maximum size of the textbox?

610


Explain option explicit?

646


Which is the base class for all the classes in .net framework?

636


Explain the difference between system.string and system.stringbuilder classes?

609


What are the shared variables?

629


Thank you for replying to my Question regarding Barcodes in VB.net. My next question is that how to use Barcode Fonts in VB.net I need a small code to Generate Barcodes in VB.net from a string of Values. This is the only problem i am left with in my project. Any body can help me please.

2125