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 vote239 views1 answer
Provera dupliranih konatakata
SQL
0 vote255 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote272 views1 answer
Alter check command
SQL
0 vote264 views1 answer
Drop all tables db2
SQL
0 vote261 views1 answer
Mysql date time string format for marshmellow field schema
SQL
2 votes254 views2 answers
Postgres set user as superuser
SQL
5 votes286 views2 answers
Oracle find all tables with column name
SQL
2 votes254 views1 answer
How to select first row of database sql
SQL
0 vote276 views1 answer
Reindex mssql table
SQL
0 vote330 views1 answer
Oracle simple quote
SQL