一条sql删除重复表重复记录

DELETE FROM s_dict WHERE id IN (
select * from ( ( select id from s_dict where name in (select name from s_dict group by name having count(name)>1))) a
)
AND id NOT IN (
select * from ((SELECT min(t.id) FROM s_dict t GROUP BY t.name HAVING count(t.name) > 1)) b)
;