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

sql satement for 2nd maximum value

Question Posted / ramavtar rajput

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

Please Help Members By Posting Answers For Below Questions

What is redim keyword?

1003

Explain convert.tostring and i.tostring method?

925

Explain an assembly?

977

What is internal keyword in .net framework?

1042

Explain about the performance of visual basic?

1034

What are different types of jit ?

1062

What is a static class?

1023

What are the advantages of migrating to vb.net?

993

What is the use of assembly?

1003

What is the significance of delegates?

964

What is the importance of a Button control?

1307

what is intermediate language?

1043

Explain the advantages of migrating to vb.net?

1024

Explain i.tostring method?

935

What is normal jit?

1058