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