MYSQL删除表中重复数据且保留一条

DELETE
FROM
    table
WHERE
    id NOT IN (//根据判断字段查出对应最小id的集合
        SELECT
            dt.min_id
        FROM
            (
                SELECT
                    MIN(id) AS min_id
                FROM
                    table
                GROUP BY
                    c_id//判断唯一字段
            ) AS dt
    )