DELETE FROM history_dists WHERE ctid NOT IN (SELECT h.ctid FROM history_dists AS h, history_dists AS h1 WHERE h.VALUE = h1.VALUE AND h.historyid = h1.historyid AND h.chance = h1.chance LIMIT 1);