PostgreSQL中删除重复行（保留一行）

delete from table_name as ta where ta.唯一键 <> ( select max(tb.唯一键) from table_name as tb where ta.判断重复的列 = tb.判断重复的列);

版权声明：本文为ljy520zhiyong原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。

原文链接：https://blog.csdn.net/ljy520zhiyong/article/details/8631264