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

4 votes283 views1 answer
For loop postgresql
SQL
0 vote278 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
1 vote300 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote289 views1 answer
Consulta alias con inner join
SQL
25 votes290 views5 answers
Date in mysql
SQL
1 vote251 views1 answer
Oracle current sequence value
SQL
0 vote269 views2 answers
Sql max count
SQL
0 vote277 views1 answer
Mysql subtract month from timestamp
SQL
0 vote275 views1 answer
Test the postgresql db connection
SQL
2 votes279 views3 answers
Mysql pass command from command line
SQL