>Hi John
>
>no because I also have several possible description groups.
> So I want the Maximum amount amongst the description groups sums for each member.
>
>Thanks
>
>Nick

;with Sums AS (select	sum(amount) as Total, ;
					member_ref, ;
					description ;
			from payments ;
				where description like '%Test%' ;
				group by member_ref, description ;
			),
Numbered as (select *, row_number() over (partition by member_ref ORDER BY Total DESC) as Rn from Sums)

select member_ref, description, Total from Numbered where Rn = 1