Query postgres delete duplicates

DELETE FROM dups a USING (
      SELECT MIN(ctid) as ctid, key
        FROM dups 
        GROUP BY key HAVING COUNT(*) > 1
      ) b
      WHERE a.key = b.key 
      AND a.ctid <> b.ctid

Similar codes

0 vote313 views1 answer
Postgresql newline character
SQL
0 vote363 views1 answer
Enable outgoing remote MySQL access
SQL
3 votes367 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
19 votes357 views3 answers
How to change column type psql
SQL
0 vote329 views1 answer
Where case insensitive like mysql
SQL
-1 vote319 views2 answers
Full join sql
SQL
0 vote340 views1 answer
Sql server concat null
SQL
0 vote351 views1 answer
Sql show table name in result
SQL
0 vote347 views1 answer
How to get specific salary in sql
SQL
1 vote332 views1 answer
Oracle aleter trigger ora-01031
SQL