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 pre-jit?

539


What is non_deterministic finalization?

620


Which control is an example of an object in vb net?

6453


Explain about visual basic.net?

661


Tell me how many .net languages can a single .net dll contain?

525






What is globalization?

553


How to store decimal data in .net?

639


Explain the difference between c# and vb.net?

551


What are the difference between structure and class?

560


What is code access security?

686


Explain about globalization?

500


Which dll is used for microsoft .net run time?

551


What is a static variable?

559


source code for how to login a vb.net application ?

593


What are the various open source tool available for VB.NET?

562