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

796


When do you use virutal keyword?

747


Explain nested classes?

709


What do you mean by serialization and deserialization and it's use.

806


Which class allows an element to be accessed using unique key?

687






What are jagged arrays ?

714


Explain the advantages of vb.net?

688


Tell me which namespace are used for accessing the data?

695


What are the parts of the visual basic control?

693


What is an arraylist?

783


What is the diff between vb mdi form and .net mdi form?

717


Is it necessary to have SQL server installed in your computer in order to create a service based database in vb.net?

2040


What is enumerator?

776


Explain global assembly cache (gac)?

903


thak you Mr Govind for replying to my question. My next question is that how to retrieve image stored in an SQL server table and assign it to any image control or picture control using VB.net

1862