mysql删除 查询重复数据

    SELECT
    sku
FROM
    nsr_retrieve
WHERE
    sku IN (
        SELECT
            sku
        FROM
            nsr_retrieve
        GROUP BY
            sku
        HAVING
            count(sku) > 1
    )

DELETE from center_base_sku WHERE (sku) in   
(SELECT sku from (SELECT sku FROM center_base_skuGROUP BY sku HAVING COUNT(*)>1) s1)   
AND  
id NOT in (SELECT id from (SELECT id FROM center_base_skuGROUP BY sku HAVING COUNT(*)>1) s2);

 

高版本可能报错

set sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';