DELETE FROM "DistrictCriminalCase" a
    USING "DistrictCriminalCase" b
WHERE
    a.id > b.id
    AND a.fips = b.fips
    AND a."CaseNumber" = b."CaseNumber";