sum()函数，需要（）把字段括起来啊

然后没有sum字段，都要在group by下面出现

==============

select post_date,city_code,city_desc,tuandui,tdmc,gasstation_code,gasstation_desc, sum(sum_gun) as '按年提枪次数',  sum_gun as '当日提枪次数' 

from app_nonoil.kl_labordata

where post_date<='${tjdate}' and year('${tjdate}')=substr(post_date,1,4)

 group by post_date,city_code,city_desc,tuandui,tdmc,gasstation_code,gasstation_desc,sum_gun

 sum sum_gun as '按年提枪次数'  应该是 sum(sum_gun ) as '按年提枪次数' 吧

sum()

如果你一个查询中 又想有 当日的数据 又想有当年的数据的话 就需要用开窗函数了 而不是简单的sum

select post_date,city_code,city_desc,tuandui,tdmc,gasstation_code,gasstation_desc, sum(sum_gun)over(parition by city_code) as '按年提枪次数', sum_gun as '当日提枪次数' from app_nonoil.kl_labordatawhere post_date<='${tjdate}' and year('${tjdate}')=substr(post_date,1,4)