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 votes199 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote209 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote218 views1 answer
Mysql preg replace
SQL
4 votes184 views1 answer
Create db table
SQL
2 votes134 views1 answer
Sql select in list
SQL
24 votes190 views4 answers
Postgres remove database
SQL
5 votes200 views4 answers
Upload database mysql command line
SQL
2 votes174 views2 answers
How to get capital letter first in sql
SQL
19 votes195 views5 answers
Change column name mysql command line
SQL
0 vote185 views1 answer
How to find sql server installation folder
SQL