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 vote384 views1 answer
Mysql value ends with
SQL
14 votes375 views3 answers
How to add default constraint in mysql
SQL
-1 vote343 views1 answer
Count occurrences sql
SQL
0 vote350 views1 answer
Initcap in mysql
SQL
0 vote392 views1 answer
Check if mysql db is used
SQL
6 votes792 views3 answers
Sql select last id
SQL
1 vote350 views1 answer
Psql datetime grather than
SQL
10 votes373 views2 answers
Mysql alter add foreign key
SQL
5 votes414 views3 answers
Sql limit offset
SQL
6 votes363 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL