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

32 votes434 views6 answers
Rename column mysql
SQL
0 vote403 views1 answer
Install mysql on bash
SQL
2 votes729 views1 answer
Oracle virtual column
SQL
-1 vote332 views1 answer
How to use update trigger in sql
SQL
12 votes374 views4 answers
How to check mysql version ubuntu
SQL
0 vote354 views1 answer
Sql reverse order of results
SQL
0 vote339 views1 answer
Print orcale
SQL
19 votes350 views5 answers
Mysql between date range
SQL
57 votes583 views5 answers
How to create a new user in postgresql
SQL
0 vote378 views1 answer
Spark sql grows beyond 64 kb
SQL