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

joel



More information about the thelist mailing list