Query 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 vote146 views3 answers
Compute age mysql
SQL
2 votes141 views1 answer
Convert series number to date in sql
SQL
3 votes148 views2 answers
Mysql config user password
SQL
0 vote146 views1 answer
Mysql bash execute sql file
SQL
4 votes169 views1 answer
List tables sqlite
SQL
2 votes146 views1 answer
Sql column values comma separated
SQL
1 vote158 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote147 views1 answer
Mysql add to number
SQL
0 vote160 views1 answer
Psql check table fields
SQL
0 vote145 views1 answer
Postgresql create table with boolean column
SQL