Sorry Antonio

I updated the message to say can I have the max for each member_ref


>Can
>

>ORDER BY total DESC
>

>do the trick?
>
>>Hi
>>
>>I have
>>
>>

>>
>>select sum(amount) as [total],
>>		member_ref,
>>		description 
>>from payments 
>>where description like '%Test%' 
>>group by member_ref,description 
>>
>>

>>
>>how can I select out only the maximum sum amount.
>>
>>Thanks
>>
>>Nick