当数据库中的键名是sum_td,我想按年份求和sum(sum_td),但结果却和sum_td一样没有求和,请问是哪里出问题了
select city_name,tdmc,store_desc, sum(sum_td) as '按年求和'
from app_ltstore.kt_store
where year('${tjdate}')=substr(post_date,1,4)
group by city_name,tdmc,store_desc,sum_td
group by city_name,tdmc,store_desc
group by 里面怎么还有sum_td