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 vote246 views1 answer
Sql roll up rows into columns
SQL
4 votes268 views1 answer
Mysql ip address data type
SQL
0 vote266 views1 answer
Into operator in sql
SQL
3 votes249 views1 answer
Oracle rollback
SQL
6 votes250 views2 answers
Sql display max value
SQL
4 votes253 views1 answer
Id primary key auto generated
SQL
1 vote268 views1 answer
Oracle create as select
SQL
1 vote256 views1 answer
Postgres set column equal to another
SQL
10 votes255 views2 answers
Forgot my mysql password mac
SQL
0 vote276 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL