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

11 votes255 views1 answer
Creating tables in sql with python
SQL
0 vote201 views3 answers
Mysql calculate age from date of birth
SQL
6 votes239 views2 answers
Where clause in sql
SQL
4 votes227 views2 answers
Tables in sql
SQL
2 votes233 views1 answer
Sql create database
SQL
2 votes235 views1 answer
Query any digits record
SQL
0 vote269 views2 answers
Temp tables in sql server
SQL
0 vote253 views1 answer
Oracle table privileges
SQL
10 votes277 views6 answers
Mysql set root password
SQL
21 votes237 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL