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

3 votes213 views4 answers
Show databases in sql server
SQL
9 votes209 views4 answers
Last mysql
SQL
-1 vote192 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote294 views1 answer
Play framework connection via windows sql server
SQL
1 vote155 views1 answer
Unique vs distinct sql
SQL
0 vote291 views1 answer
Mysql show schema
SQL
-1 vote196 views1 answer
What is in operator
SQL
51 votes445 views6 answers
Installing mysql on ubuntu
SQL
8 votes160 views1 answer
Similarities between ddl and dml
SQL
0 vote215 views1 answer
Name '_mysql' is not defined
SQL