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 vote327 views1 answer
How to fetch unique records from two tables
SQL
11 votes308 views1 answer
How to get ddl for materialized view
SQL
0 vote344 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote286 views1 answer
Get only first row mysql
SQL
23 votes324 views3 answers
Mysqldump
SQL
1 vote335 views1 answer
Mysql show queries running
SQL
0 vote366 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote317 views1 answer
Postgresql alter column nullable
SQL
0 vote325 views1 answer
How to print mysql query of codeigniter query builder
SQL
9 votes346 views3 answers
Date format in sql
SQL