Find duplicate access cards assigned to people

global=> select count(*), encoded_number FROM personinfo.access_cards GROUP BY 2 having count(*)>1;

count | encoded_number

-------+----------------

2 | 166772
2 | 166118
2 | 166123

(3 rows)

global=> BEGIN;

BEGIN

global=> delete from personinfo.access_cards where access_card_id IN ('130275','130186','130891');

DELETE 3

global=> select count(*), encoded_number FROM personinfo.access_cards GROUP BY 2 having count(*)>1;

count | encoded_number

-------+----------------

(0 rows)

global=> COMMIT;

COMMIT

global=> select count(*), encoded_number FROM personinfo.access_cards GROUP BY 2 having count(*)>1;

count | encoded_number

-------+----------------

(0 rows)