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 vote224 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote204 views1 answer
Sql values not in another table
SQL
1 vote199 views2 answers
Replace text in sql
SQL
0 vote204 views1 answer
Oracle array
SQL
0 vote221 views1 answer
Postgresql create query
SQL
4 votes223 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote191 views1 answer
Oracle job class
SQL
0 vote206 views1 answer
How to execute stored output to csv files
SQL
0 vote209 views1 answer
Show table details postgresql
SQL
20 votes221 views3 answers
Update values in select statement sql
SQL