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 vote234 views1 answer
Find difference in dates sql
SQL
0 vote191 views1 answer
Can we rollback deleted data in sql
SQL
0 vote205 views1 answer
Hotw to alter lengh character vayng postgres
SQL
1 vote224 views1 answer
Oracle drop temporary table
SQL
0 vote201 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote221 views1 answer
Sql query use select name inside where clause
SQL
0 vote199 views1 answer
Sql server select ignore dupplicates
SQL
0 vote200 views1 answer
Sqlplus change user
SQL
0 vote208 views1 answer
How to find database collation in postgres
SQL
1 vote225 views3 answers
Sql procedure
SQL