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

11 votes257 views2 answers
Having clause
SQL
0 vote277 views1 answer
Firebird where
SQL
24 votes279 views6 answers
Replace mysql
SQL
1 vote268 views2 answers
Change table name phpmyadmin
SQL
2 votes302 views1 answer
How to select from mssql
SQL
2 votes277 views1 answer
Mysql create user with mysql_native_password
SQL
1 vote274 views1 answer
Drush sql-dump
SQL
4 votes280 views2 answers
Show all database inside postgresql
SQL
0 vote277 views2 answers
How to set global time_zone in mysql
SQL
3 votes296 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL