[thelist] What's wrong with my query?

Matt Warden mwarden at gmail.com
Thu May 17 15:02:23 CDT 2007


On 5/17/07, Casey Crookston <caseyc at intellisoftmn.com> wrote:
> ID            Business_Name               Points Awarded
>
> ----------------------------------------------------------
>
> 1              tom and jerry                    15
>
> 2              tom and jerry                    75
>
> 3              tom and jerry                    20
>
> 4              abbott and costello        5
>
> 5              abbott and costello        90
>
>
>
> I'd like to return this result:
>
>
>
> tom and jerry                    110
>
> abbot and costello          95

select Business_Name, sum([Points Awarded])
from tablename
group by Business_Name

-- 
Matt Warden
Cleveland, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.



More information about the thelist mailing list