Query design

E

ehsham

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.
 
O

Ofer Cohen

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

Select Top 2 ValueFiledName From TableName Order By ValueFiledName Desc
 
Top