Query design

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Using the query with "sort Desc" and "Top 2" Values

Select Top 2 ValueFiledName From TableName Order By ValueFiledName Desc
 
Back
Top