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

0 vote107 views1 answer
Sql server isnull function nor working count
SQL
1 vote76 views3 answers
Grant syntax in sql
SQL
0 vote109 views1 answer
Connexion mysql
SQL
0 vote132 views1 answer
Select count concat string sql server
SQL
14 votes106 views2 answers
How to auto increment in sql
SQL
2 votes102 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote103 views1 answer
Sql server select furst day of current year
SQL
4 votes107 views1 answer
Oracle select first 10 rows
SQL
0 vote127 views1 answer
Mysql get only the field names in a table
SQL
31 votes118 views4 answers
Mysql grant execute
SQL