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

4 votes313 views1 answer
To date oracle with time
SQL
0 vote345 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote322 views1 answer
Select from another database
SQL
0 vote366 views1 answer
How to find all children of a record with only parent ID in sql
SQL
1 vote324 views1 answer
Last 6 months postgresql
SQL
47 votes395 views6 answers
Add column mysql
SQL
0 vote342 views1 answer
Mysql query to select the highest value
SQL
0 vote315 views1 answer
Psql no such file or directory
SQL
0 vote362 views1 answer
Sql create and grant user access to database
SQL
1 vote311 views1 answer
Input in mysql
SQL