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 vote174 views1 answer
Sql delete caracter list
SQL
0 vote163 views1 answer
Mysql conf.d exampel
SQL
3 votes133 views2 answers
Mysql create database
SQL
2 votes134 views1 answer
Update with join sql server
SQL
8 votes156 views1 answer
Declare table variable sql server
SQL
0 vote156 views1 answer
How to create a new db from dumb file mysql
SQL
21 votes139 views3 answers
Sql average
SQL
7 votes160 views1 answer
Sql limit decimal places
SQL
0 vote151 views1 answer
Mysql check datetime equals date
SQL
2 votes150 views1 answer
Mariadb select multiple rows into one column
SQL