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 vote330 views2 answers
Mysql add column tinyint default 0
SQL
0 vote314 views1 answer
Postgres get database encoding
SQL
1 vote303 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
3 votes338 views1 answer
What is having
SQL
0 vote325 views1 answer
Alter table change default
SQL
0 vote292 views1 answer
Postgres copy command
SQL
0 vote330 views1 answer
Pl sql disable trigger
SQL
0 vote292 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote291 views1 answer
Import sql dump into postgresql database
SQL
7 votes300 views3 answers
Add primary key to database sql
SQL