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 vote231 views1 answer
Ubuntu access database from terminal
SQL
0 vote199 views1 answer
Postgres sql alter table delete row
SQL
0 vote196 views1 answer
Select from 3 tables one is empty
SQL
0 vote204 views1 answer
Renommer table sql
SQL
0 vote252 views1 answer
Prisma transaction
SQL
0 vote199 views1 answer
Get role postgres
SQL
1 vote188 views3 answers
Mariadb add foreign key
SQL
23 votes272 views2 answers
Query to delete a database in mysql
SQL
0 vote209 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote210 views2 answers
Oracle create tablespace autoextend
SQL