1、问题描述

2、解决方案

该问题先修复数据

--查询是否有重复脏数据

SELECT FORGID,FUSERID,FTYPE FROM T_PM_ORGRANGE group by FORGID,FUSERID,FTYPE having count(1)>1

注意：如上述查询有结果则执行下面方案

--备份

SELECT * into T_PM_ORGRANGE_bak1110 FROM T_PM_ORGRANGE

--检查是否备份成功

select count(1) from T_PM_ORGRANGE_bak1110

--删除脏数据

DELETE FROM T_PM_ORGRANGE WHERE fid not in (SELECT max(Fid) FROM T_PM_ORGRANGE group by FORGID,FUSERID,FTYPE having count(1)>1) and fid in (SELECT t1.fid FROM T_PM_ORGRANGE t1 

in