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 votes338 views5 answers
Get last query in codeigniter 4
SQL
1 vote321 views1 answer
Launch sql script from docker in mysql
SQL
21 votes313 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote317 views1 answer
Jenkins SQLCMD run
SQL
1 vote324 views3 answers
Connection string mysql
SQL
11 votes349 views2 answers
Having clause in sql
SQL
4 votes305 views1 answer
Delete record mysql query
SQL
0 vote327 views1 answer
Oracle date winter time
SQL
6 votes342 views3 answers
Rename column ORACLE
SQL
0 vote346 views1 answer
Get statis values sql
SQL