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 vote311 views1 answer
Grant privileges mysql to database 1064
SQL
2 votes311 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote312 views1 answer
Sql ignore
SQL
0 vote315 views1 answer
Soql update query
SQL
0 vote300 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote284 views1 answer
SQL Server format datetime
SQL
4 votes395 views3 answers
Mysql get column names from table
SQL
0 vote325 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote313 views1 answer
Every Derived yable must have its own alias
SQL
1 vote330 views4 answers
Get week day from date in sql
SQL