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

1 vote204 views1 answer
OSError: mysql_config not found
SQL
1 vote176 views1 answer
Mysql f# examples
SQL
3 votes185 views4 answers
Truncate syntax in sql
SQL
0 vote218 views1 answer
How to create notes in mysql
SQL
2 votes184 views5 answers
Eloquest how to select one specific column in database
SQL
5 votes166 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote170 views1 answer
Mysql read row
SQL
0 vote163 views1 answer
How to get data between a last week in mysql
SQL
2 votes168 views1 answer
How to select first row of database sql
SQL
10 votes177 views2 answers
Mysql drop database if exists
SQL