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 vote220 views1 answer
Postgresql show owner of database
SQL
0 vote209 views1 answer
Create column that already exists mysql
SQL
0 vote242 views1 answer
Sql today at midnight
SQL
2 votes216 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote223 views1 answer
Sql server express download
SQL
0 vote240 views1 answer
How to select only a certain date sql
SQL
0 vote209 views1 answer
Sql roll up rows into columns
SQL
5 votes200 views1 answer
Oracle get nls settings
SQL
1 vote220 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
1 vote224 views2 answers
Mysql error 1215
SQL