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

3 votes123 views2 answers
How to start mysql in terminal
SQL
18 votes119 views3 answers
Mysql add column with default value
SQL
3 votes140 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote154 views1 answer
Mysl like insert a variable
SQL
0 vote107 views1 answer
Sql pad left 0
SQL
0 vote103 views1 answer
Vbscript create ADODB.Connection
SQL
1 vote118 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote123 views1 answer
How to close external sql connection in laravel
SQL
0 vote122 views1 answer
View to table sql
SQL
2 votes123 views1 answer
Oracle sql merge
SQL