Query 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 vote139 views1 answer
Delete from inner join sql
SQL
5 votes143 views1 answer
How to get all table names in sql query
SQL
1 vote120 views1 answer
Mysql drop key
SQL
1 vote203 views1 answer
Oracle create program if not exists
SQL
2 votes142 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote147 views1 answer
Full outer join in mariadb mysql
SQL
1 vote161 views1 answer
Drop colum oracle 18c
SQL
-1 vote166 views1 answer
Brisanje dupliranih konatakata
SQL
5 votes121 views1 answer
Sqlite alter table add column
SQL
0 vote142 views1 answer
Template MySQL Zabbix agent
SQL