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

-1 vote199 views1 answer
Plsql while
SQL
0 vote234 views1 answer
Sql server alter table column nullable
SQL
1 vote255 views1 answer
Default
SQL
1 vote221 views1 answer
Local sql server
SQL
0 vote235 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote303 views2 answers
Mysql insert rows to another database
SQL
0 vote256 views2 answers
How to drop mili second in sql
SQL
1 vote249 views1 answer
Insert value to new table by joining 2 different tables
SQL
11 votes259 views1 answer
Oracle export view ddl
SQL
0 vote273 views1 answer
Update mysql from paypal shopping cart and ipn
SQL