请使用此代码:
DELETE
FROM
corporate
WHERE
corporate_sed_id IN(
SELECT
*
FROM
(
SELECT
MIN(corporate_sed_id)
FROM
corporate
GROUP BY
corporate_id,
category_id
HAVING
COUNT(corporate_sed_id) > 1
) temp
)