根据多个字段删除重复数据

DELETE FROM statproductsaleamount WHERE ID NOT IN 
(
　　SELECT OneId FROM
    (
        SELECT
        MIN(ID) AS OneId,
        count(*) AS count
        FROM
        statproductsaleamount
        GROUP BY
        ShopName,DateOfData,supercode,pcode,scost
        HAVING
        count(*) >= 1
    ) m
)