select grp_id,sum(WRTOF_AMT) as pay from bass.DM_GRP_ACC_INFO_CHARGE_MM where stat_month=201904 group by grp_id having pay>0
此查询可以执行
select grp_id,sum(WRTOF_AMT)/100 as pay from bass.DM_GRP_ACC_INFO_CHARGE_MM where stat_month=201904 group by grp_id having pay>0
此查询为什么报错?