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 vote181 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
1 vote140 views1 answer
Oracle split string
SQL
4 votes168 views1 answer
Is there any command to change postgres password
SQL
1 vote171 views1 answer
Postgres install unaccent extension
SQL
3 votes137 views1 answer
What is having clause
SQL
4 votes135 views3 answers
Copy table postgres
SQL
3 votes144 views1 answer
Select nextval from sequence sql
SQL
0 vote147 views1 answer
Mssql now diff 90 day
SQL
0 vote147 views1 answer
PostgreSQL types and C# types
SQL
0 vote166 views1 answer
Query builder doctrien return sql
SQL