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

0 vote267 views1 answer
How to check rollback status in oracle
SQL
0 vote236 views1 answer
Sql server list table sizes
SQL
12 votes227 views10 answers
Google
SQL
4 votes246 views5 answers
Get last query in codeigniter 4
SQL
0 vote185 views1 answer
Print sum of values sql
SQL
0 vote225 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote197 views1 answer
CREATE MULTIPLE FK
SQL
0 vote233 views1 answer
How to write if case in select query in select statement
SQL
0 vote249 views2 answers
Faster mysql imports
SQL
1 vote254 views1 answer
Mysql update inner
SQL