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 vote208 views1 answer
Reset keys in sql
SQL
0 vote205 views1 answer
Sql bild in function
SQL
0 vote200 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote208 views1 answer
St_buffer mysql
SQL
0 vote224 views1 answer
Call function in query sql server
SQL
4 votes195 views1 answer
Wildcard in sql
SQL
0 vote236 views1 answer
Connect to nginx server mysql remotly
SQL
1 vote232 views1 answer
Nvl postgres
SQL
1 vote199 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote220 views1 answer
No suitable driver found for sqlite
SQL