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 vote170 views1 answer
Declare date variable sql
SQL
4 votes176 views2 answers
Mysql how to change default charset
SQL
5 votes206 views3 answers
Show indexes mysql
SQL
0 vote174 views1 answer
Firebase sql
SQL
1 vote166 views1 answer
Sql Split string function
SQL
8 votes230 views6 answers
Insert command in sql
SQL
0 vote239 views1 answer
Sql select rows between 1000 and 2000
SQL
1 vote188 views1 answer
Name of today sql
SQL
0 vote186 views1 answer
Plpgsql raise notice
SQL
0 vote196 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL