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