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

Which namespace are used for accessing the data?

1251

What are the differences between vb.net and c#, related to oops concepts

971

Using VB, how can you change the Mouse Pointer?

1106

Why should you use delegate?

915

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

943

How to run a dos command in vb.net?

1041

What is a literal control?

1013

Explain the difference between namespace and assembly?

1001

Explain the use of new keyword?

926

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

1003

How vb implements the disconnected architecture as like vb.net?

1014

how to deploy vb.net with key and evaluation time? any one can help me?

2207

Explain about visual basic.net?

1236

Can you please explain the difference between int and int32?

1076

Observations between vb.net and vc#.net?

1055