mysql删除相同数据的最小ID

DELETE
FROM
    shop
WHERE
    company_id IN (
        SELECT * FROM (
        SELECT
            company_id
        FROM
            shop
				where valid = 1
        GROUP BY
            company_id
        HAVING
            count(company_id) > 1
          ) b
    ) and  id NOT IN (
        SELECT * FROM (
        SELECT
            max(id)
        FROM
            shop
				where valid = 1
        GROUP BY
            company_id
        HAVING
            count(company_id) > 1
          ) c
    );