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 vote158 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote151 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote196 views1 answer
Mariadb disable foreign key checks
SQL
0 vote159 views1 answer
What is initial catalog in sql connection string
SQL
0 vote187 views1 answer
Sqlite unique multiple columns
SQL
0 vote157 views1 answer
Sql sum if
SQL
2 votes154 views1 answer
Columns Present in a table
SQL
0 vote149 views1 answer
Java sql insert return id
SQL
5 votes217 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
5 votes339 views2 answers
How to ascending order in sql
SQL