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 vote191 views1 answer
Create view in sql server that contain multiple select statements
SQL
5 votes201 views5 answers
Find max number in sql
SQL
0 vote170 views1 answer
C# add a textbox in mysql select
SQL
0 vote170 views1 answer
Compare field sql server
SQL
9 votes163 views2 answers
Cmd to rename a collumn name in sql
SQL
5 votes167 views1 answer
JBDC
SQL
23 votes163 views6 answers
How to create table in sql
SQL
1 vote171 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote170 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote174 views1 answer
On update current_timestamp jpa
SQL