sql="SELECT daydata_workerid,sum(daydata_piece),daydata_teamid,daydata_productid,daydata_processid FROM daydata group by daydata_workerid,daydata_piece,daydata_teamid,daydata_productid,daydata_processid" 正确答案为:
统计时每个使用的字段都要在 Group By 中出现
前面select选择的字段,都要在后面的group by 中出现,就不会出现这种错误!
group by 后面跟的各个字段,是按第一个字段为主关健字,后面是依次为二、三.....等.