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 vote192 views1 answer
Group by sql not ordering issues
SQL
2 votes188 views1 answer
How to delete view in sql
SQL
0 vote238 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote703 views1 answer
T sql less than date
SQL
0 vote199 views1 answer
Oracle service name view
SQL
0 vote178 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote215 views1 answer
Play framework connection via windows sql server
SQL
1 vote231 views3 answers
Divide by zero error in sql
SQL
2 votes225 views1 answer
Sql get the name of user pc
SQL
23 votes261 views2 answers
Query to delete a database in mysql
SQL