[thelist] What's wrong with my query?

Joel D Canfield joel at streamliine.com
Thu May 17 15:18:17 CDT 2007

> > tom and jerry                    110
> > abbot and costello          95
>     select business_name, sum(points_awarded) from yourtable
>     order by business_name, group by business_name

ach; for those exact results, either leave out 'order by business_name'
or specify 'order by business_name desc'


More information about the thelist mailing list