-- 删除FunctionGUID重复的记录
delete from myFunctionConfig where myFunctionConfigId not in (
select t.max_id from
(select max(myFunctionConfigId) as max_id from myFunctionConfig group by FunctionGUID) as t
);
-- 删除FunctionGUID重复的记录
delete from myFunctionConfig where myFunctionConfigId not in (
select t.max_id from
(select max(myFunctionConfigId) as max_id from myFunctionConfig group by FunctionGUID) as t
);