Remove Duplicates in Postgresql

 2018.12.9  Post  46  1 分钟

1
2
3
4
5
6
7
8

DELETE
FROM des_table
WHERE id IN (SELECT id
            FROM des_table
            WHERE dup_col IN (SELECT dup_col FROM des_table GROUP BY dup_col HAVING count(dup_col) > 1))
	AND id NOT IN (SELECT min(id)
                  FROM des_table
                  WHERE dup_col IN (SELECT dup_col FROM des_table GROUP BY dup_col HAVING count(dup_col) > 1));

1
2
3

DELETE
FROM dst_table
WHERE id NOT IN (SELECT max(id) FROM dst_table GROUP BY dup_col);