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

-1 vote238 views5 answers
Left join sql
SQL
0 vote147 views1 answer
Drop tables from local database postgres pgadmin
SQL
15 votes340 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote193 views1 answer
Creating sqeuence in oracle database
SQL
1 vote181 views1 answer
Sqlalchemy on delete set null
SQL
0 vote154 views1 answer
Create database store
SQL
0 vote174 views1 answer
Mysql show create db
SQL
0 vote146 views1 answer
Set default value now() date
SQL
4 votes138 views1 answer
Oracle session date format
SQL
0 vote151 views1 answer
Mysql drop multiple tables at once
SQL