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 vote170 views1 answer
Mysql join same table multiple times group by
SQL
103 votes2.4K views1 answer
Like sql
SQL
0 vote179 views1 answer
Exectuer myssql .sql
SQL
1 vote216 views1 answer
Sqlalchemy on delete set null
SQL
-1 vote121 views2 answers
On delete set default sql server
SQL
0 vote160 views1 answer
Check if record exists mysql
SQL
1 vote185 views1 answer
Postgresql datetrunc too slow
SQL
0 vote166 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote202 views1 answer
SQL Cut part string
SQL
0 vote197 views1 answer
Duplicate value unique constraint mysql error
SQL