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

1 vote384 views1 answer
Sql and
SQL
0 vote318 views1 answer
Nvl2 syntax
SQL
0 vote301 views1 answer
Soql update query
SQL
6 votes347 views2 answers
How to get last element sql
SQL
0 vote309 views1 answer
Mssql disable foreign key constraint
SQL
9 votes321 views3 answers
Mysql run sql file
SQL
0 vote302 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
3 votes307 views2 answers
Find string in stored procedure sql server
SQL
0 vote302 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote301 views1 answer
Sql server select record with max id
SQL