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

2 votes106 views1 answer
Oracle apex list connected users
SQL
0 vote149 views1 answer
Postgres extract number from string
SQL
0 vote106 views1 answer
Renombrar tabla mysql
SQL
18 votes104 views3 answers
Get the list of all tables in sql server
SQL
0 vote94 views1 answer
How to find top 3 salary in sql
SQL
0 vote99 views1 answer
Mysql concat and use as where column
SQL
7 votes115 views3 answers
Convert ansi sql
SQL
7 votes111 views2 answers
Get database size mysql
SQL
0 vote108 views1 answer
Oracle sql date summer time
SQL
0 vote109 views1 answer
Database traccar
SQL