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 vote130 views1 answer
Download sql file of countries names
SQL
0 vote119 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote127 views1 answer
We are intrested to work with your organization
SQL
1 vote133 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
1 vote139 views1 answer
How to put value in variable mysql
SQL
7 votes131 views1 answer
Connect mysql docker
SQL
0 vote142 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote130 views2 answers
Dbms interview questions
SQL
0 vote130 views1 answer
Mysql docker image arjun
SQL
0 vote114 views1 answer
Mysql workbench indent formatting
SQL