pgsql 删除重复的记录

DELETE
FROM
t_social_security a
WHERE
a.id <> ( SELECT MIN ( b.id ) FROM t_social_security b WHERE A.certificatenum = b.certificatenum );