delete from bizdata_cwbj.cm_fin_fb1 j where j.syear = 2009 and (SCOMPANYCODE, SYEAR, SMONTH, SRPTYPE, SSEGCODE, SSEGNAME) in (select SCOMPANYCODE, SYEAR, SMONTH, SRPTYPE, SSEGCODE, SSEGNAME from bizdata_cwbj.cm_fin_fb1 group by SCOMPANYCODE, SYEAR, SMONTH, SRPTYPE, SSEGCODE, SSEGNAME having count(*) > 1) and rowid not in (select max(rowid) from bizdata_cwbj.cm_fin_fb1 group by SCOMPANYCODE, SYEAR, SMONTH, SRPTYPE, SSEGCODE, SSEGNAME having count(*) > 1)
删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid最大的记录
最新推荐文章于 2021-07-02 16:52:25 发布