select 日期,区域,Hour0,Hour1,Hour2,Hour3,sum(Hour0,Hour1,Hour2,Hour3) as 总量 from 表名 where 日期 between‘$starttime’and'$endtime'${if(len(zone) == 0,"","and sZoneName in ('" + zone + "')")}(时间与区域是参数控件) group by 日期,区域,Hour0,Hour1,Hour2,Hour3 可是提示说sum不能这样用,请教各位应该怎么改正 编辑于 2017-11-15 09:02 编辑于 2017-11-15 09:03 编辑于 2017-11-15 09:14 |
最佳回答 |
||||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|