pgsql 删除重复的记录

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

posted @ 2023-07-21 16:52  漫步CODE人生  阅读(46)  评论(0编辑  收藏  举报