去重

DELETE
FROM
    house_damage_ledger
WHERE
    (area_code, household_head_id) IN (
        SELECT
            t.area_code, t.household_head_id
        FROM
            (
                SELECT
                    area_code, household_head_id
                FROM
                    house_damage_ledger
                GROUP BY
                    area_code, household_head_id
                HAVING
                    count(1) > 1
            ) t
    )
AND house_damage_id NOT IN (
SELECT max(house_damage_id) AS mindeptno FROM house_damage_ledger
GROUP BY area_code, household_head_id
HAVING count(1) > 1 )