Query design

[Guest]

I have a four value example A, B, C and D.
Value A=56,
Value B=70,
Value C=80 and
Value D=30.
So, how to get the two higher value from value A,B,C and D.

 

[Guest]

Using the query with "sort Desc" and "Top 2" Values

Select Top 2 ValueFiledName From TableName Order By ValueFiledName Desc