delete from t_tccit_dg_a100000_1 where not exists (select id from (select max(fid) as id from t_tccit_dg_a100000_1 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_a100000_2 where not exists (select id from (select max(fid) as id from t_tccit_dg_a100000_2 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_a100000_3 where not exists (select id from (select max(fid) as id from t_tccit_dg_a100000_3 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_a101010 where not exists (select id from (select max(fid) as id from t_tccit_dg_a101010 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_a101020 where not exists (select id from (select max(fid) as id from t_tccit_dg_a101020 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_a102010 where not exists (select id from (select max(fid) as id from t_tccit_dg_a102010 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_a102020 where not exists (select id from (select max(fid) as id from t_tccit_dg_a102020 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_a103000 where not exists (select id from (select max(fid) as id from t_tccit_dg_a103000 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_a104000 where not exists (select id from (select max(fid) as id from t_tccit_dg_a104000 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_a105000_2 where not exists (select id from (select max(fid) as id from t_tccit_dg_a105000_2 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_b105014_1 where not exists (select id from (select max(fid) as id from t_tccit_dg_b105014_1 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_b105014_2 where not exists (select id from (select max(fid) as id from t_tccit_dg_b105014_2 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_b105014_3 where not exists (select id from (select max(fid) as id from t_tccit_dg_b105014_3 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_b105015 where not exists (select id from (select max(fid) as id from t_tccit_dg_b105015 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_b105016 where not exists (select id from (select max(fid) as id from t_tccit_dg_b105016 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_b105017 where not exists (select id from (select max(fid) as id from t_tccit_dg_b105017 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_b105018 where not exists (select id from (select max(fid) as id from t_tccit_dg_b105018 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_b105023_2 where not exists (select id from (select max(fid) as id from t_tccit_dg_b105023_2 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_b105023_1 where not exists (select id from (select max(fid) as id from t_tccit_dg_b105023_1 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_zb where not exists (select id from (select max(fid) as id from t_tccit_qysds_zb group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_msyhmx where not exists (select id from (select max(fid) as id from t_tccit_qysds_msyhmx group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_gdzczjyhmx where not exists (select id from (select max(fid) as id from t_tccit_qysds_gdzczjyhmx group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_jmsdsyh where not exists (select id from (select max(fid) as id from t_tccit_qysds_jmsdsyh group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_fzjgxx where not exists (select id from (select max(fid) as id from t_tccit_qysds_fzjgxx group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_zjgxx where not exists (select id from (select max(fid) as id from t_tccit_qysds_zjgxx group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_wgqyxx where not exists (select id from (select max(fid) as id from t_tccit_qysds_wgqyxx group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_gdxx where not exists (select id from (select max(fid) as id from t_tccit_qysds_gdxx group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_dsxx where not exists (select id from (select max(fid) as id from t_tccit_qysds_dsxx group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_sggfxx where not exists (select id from (select max(fid) as id from t_tccit_qysds_sggfxx group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_czgfxx where not exists (select id from (select max(fid) as id from t_tccit_qysds_czgfxx group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_dynsbab where not exists (select id from (select max(fid) as id from t_tccit_qysds_dynsbab group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_jmmx_2015 where not exists (select id from (select max(fid) as id from t_tccit_qysds_jmmx_2015 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_fzjgfp_2015 where not exists (select id from (select max(fid) as id from t_tccit_qysds_fzjgfp_2015 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_gdzc_2015 where not exists (select id from (select max(fid) as id from t_tccit_qysds_gdzc_2015 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_zb_2015 where not exists (select id from (select max(fid) as id from t_tccit_qysds_zb_2015 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_jmsd_2015 where not exists (select id from (select max(fid) as id from t_tccit_qysds_jmsd_2015 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_hdzs_b_2015 where not exists (select id from (select max(fid) as id from t_tccit_hdzs_b_2015 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_hsqjsbb_b_2018 where not exists (select id from (select max(fid) as id from t_tccit_hsqjsbb_b_2018 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_jdtbxx where not exists (select id from (select max(fid) as id from t_tccit_qysds_jdtbxx group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dg_a109010 where not exists (select id from (select max(fid) as id from t_tccit_dg_a109010 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105120_dk where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105120_dk group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a104000 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a104000 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105000 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105000 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105010 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105010 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105020 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105020 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105030 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105030 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105040 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105040 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105050 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105050 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105060 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105060 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105070 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105070 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105080 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105080 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_tab where not exists (select id from (select max(fid) as id from t_tccit_qysds_tab group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105090 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105090 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105100 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105100 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105110 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105110 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a105120 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a105120 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a106000 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a106000 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a107010 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a107010 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a107011 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a107011 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a107012_mx where not exists (select id from (select max(fid) as id from t_tccit_qysds_a107012_mx group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a107020 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a107020 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a000000 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a000000 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a000000_gd where not exists (select id from (select max(fid) as id from t_tccit_qysds_a000000_gd group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a107030 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a107030 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a107040 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a107040 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a107041 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a107041 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a107042 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a107042 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a107050 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a107050 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a108000 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a108000 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a108010 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a108010 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a108020 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a108020 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a108030 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a108030 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a109000 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a109000 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a100000 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a100000 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a109010_fz where not exists (select id from (select max(fid) as id from t_tccit_qysds_a109010_fz group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a109010_zjg where not exists (select id from (select max(fid) as id from t_tccit_qysds_a109010_zjg group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a107042_ba where not exists (select id from (select max(fid) as id from t_tccit_qysds_a107042_ba group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a101010 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a101010 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a101020 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a101020 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a102010 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a102010 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a102020 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a102020 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_a103000 where not exists (select id from (select max(fid) as id from t_tccit_qysds_a103000 group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_dksszbj_summary where not exists (select id from (select max(fid) as id from t_tccit_dksszbj_summary group by fewblxh, fsbbid) t where t.id=fid);
delete from t_tccit_qysds_ext where not exists (select id from (select max(fid) as id from t_tccit_qysds_ext group by fewblxh, fsbbid) t where t.id=fid);