Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select max sum amount
Message
From
06/09/2011 11:07:48
John Baird
Coatesville, Pennsylvania, United States
 
 
To
06/09/2011 10:59:05
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01522791
Message ID:
01522795
Views:
39
>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

I'm missing something here, if you select the sum(amount) for each member_ref grouped by member_ref, then isn't the sum of the total for each member_ref, therefore, the max?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform