/******  删除重复的组织视图数据 ******/
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure WHERE FID in (SELECT t.FID from (SELECT MAX(FID) FID from t_org_structure GROUP BY FVIEWID,FORGID HAVING COUNT(1) > 1) AS t);
DELETE FROM t_org_structure_l WHERE  FID>0 and FID not in (SELECT FID from t_org_structure);