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 vote364 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote320 views1 answer
Sql select by content lenght
SQL
2 votes342 views2 answers
Convert_tz mysql
SQL
10 votes327 views1 answer
Oracle object dependencies
SQL
0 vote322 views1 answer
Mysql find missing values
SQL
0 vote341 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote360 views10 answers
Sql statement checker corrector
SQL
0 vote418 views1 answer
How to show current database in mysql
SQL
3 votes343 views1 answer
Oracle APEX elapsed time
SQL
8 votes363 views3 answers
Postgres database sizes
SQL