| 123456789101112 |
- -- 8.16
- vector."TB_NZYSJ_NEW"
- vector."AFTER_NZYSJ_NEW"
- vector.gdbh_zbph
- --8.13
- UPDATE base.t_jsc_sql
- SET jsc_sql='SELECT round(coalesce(sum(zy_gdmj),0),2)zy_gdmj,round(coalesce(sum(zy_st),0),2) zy_st,round(coalesce(sum(zy_cn),0)/1000,2) zy_cn, round(coalesce(sum(cb_gdmj),0),2) cb_gdmj,round(coalesce(sum(cb_st),0),2) cb_st,round(coalesce(sum(cb_cn),0)/1000,2) cb_cn, #{id} as id ,#{begin_time} as create_time FROM vector.gdbh_zbph x where xzqhdm like #{id}||''%'' AND pzrq >= #{begin_time} AND pzrq < #{end_time}'
- -- 同步数据
- -- base.t_fzss_fzxz_factor_temp
- -- base.t_fzss_fzxz_factor
|
