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 vote305 views1 answer
How to output a different column name in mysql
SQL
1 vote295 views1 answer
Postgres format date in select
SQL
1 vote306 views1 answer
Update and replace mysql
SQL
0 vote313 views2 answers
Android sqlite query join
SQL
2 votes320 views1 answer
Orcale index size
SQL
7 votes310 views3 answers
Python and mysql connectivity
SQL
7 votes308 views1 answer
Oracle reset sequence
SQL
31 votes300 views1 answer
Postgresql add column with constraint
SQL
15 votes558 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote310 views1 answer
How to declare variable date in mysql
SQL