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 vote160 views3 answers
Reseed sql table primary key
SQL
0 vote126 views1 answer
Mysql start of today
SQL
25 votes143 views4 answers
Metadata
SQL
0 vote147 views1 answer
Sql log file inof
SQL
0 vote130 views1 answer
Connexion mysql
SQL
7 votes131 views2 answers
Phpmyadmin change password
SQL
1 vote135 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote137 views1 answer
Allow external access to mysql
SQL
0 vote123 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote139 views1 answer
Joins vs includes
SQL