深圳mySql删除重复记录，保留最小的一条

DELETE FROM '表' WHERE id IN (
    SELECT id from (
        SELECT id FROM '表' WHERE '重复字段' in(
            SELECT '重复字段' FROM '表' GROUP BY '重复字段' HAVING count('重复字段') > 1)
            AND id  not IN(SELECT min(id) FROM '表' GROUP BY '重复字段' HAVING count('重复字段') > 1)
    ) as t
);

SELECT id FROM '表' WHERE '重复字段' in(
    SELECT '重复字段' FROM '表' GROUP BY '重复字段' HAVING count('重复字段') > 1)
    AND id  not IN(SELECT min(id) FROM '表' GROUP BY '重复字段' HAVING count('重复字段') > 1);