Query postgres 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 vote187 views1 answer
Search In the Database using Text
SQL
13 votes193 views6 answers
Restart postgresql
SQL
1 vote213 views1 answer
Psql show with user is logged in
SQL
0 vote251 views1 answer
Arithmetic expression in sql
SQL
0 vote227 views1 answer
Sqlcmd no headers
SQL
20 votes220 views6 answers
Creating a table in sql
SQL
4 votes331 views2 answers
Sql select except null
SQL
1 vote199 views1 answer
Loading local data is disabled mysql
SQL
0 vote352 views1 answer
Sqlite display data in separated columns
SQL
0 vote221 views1 answer
Mysql join table with a text columns with ids splited by char
SQL