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

2 votes164 views3 answers
Postgres json to string
SQL
3 votes135 views4 answers
Show sql server database
SQL
1 vote130 views1 answer
Drop table if exists oracle
SQL
0 vote158 views1 answer
Sql last time database was accessed
SQL
0 vote144 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote129 views1 answer
Json not contains mysql
SQL
2 votes136 views1 answer
Possgress drop if exists table
SQL
0 vote148 views1 answer
Mysql group by range
SQL
0 vote133 views1 answer
Sql datediff db2
SQL
0 vote140 views1 answer
Renombrar tabla mysql
SQL