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 vote143 views8 answers
Create Trigger in phpMyAdmin
SQL
13 votes145 views3 answers
Insert mysql ifile nto database
SQL
0 vote100 views1 answer
Check sql query executed wp
SQL
0 vote134 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote143 views1 answer
Sql server set complex constraints
SQL
0 vote137 views1 answer
Sql gather statistics to increase performance
SQL
3 votes160 views2 answers
Mysql select database
SQL
0 vote141 views1 answer
Oracle job class
SQL
5 votes145 views1 answer
Mysql count lines
SQL
3 votes142 views1 answer
Only join in sql
SQL