Prevent duplicate rows in postgres

Postgresql remove duplicate rows 2 columns

DELETE FROM sf_table
WHERE id IN
    (SELECT id
    FROM 
        (SELECT id,
         ROW_NUMBER() OVER( PARTITION BY tosp, icd
        ORDER BY  id ) AS row_num
        FROM sf_table ) t
        WHERE t.row_num > 1 );

Source: grepper.com

Similar codes

0 vote154 views1 answer
What is mysql_pconnect
SQL
0 vote144 views1 answer
Pl sql join 3 tables
SQL
0 vote180 views1 answer
Alter database name script
SQL
0 vote148 views1 answer
Mysql terminal run sql file
SQL
2 votes129 views1 answer
Mysql auto increment jumping
SQL
0 vote165 views1 answer
Last date for each user sql
SQL
3 votes137 views4 answers
Ubuntu stop mysql
SQL
0 vote144 views1 answer
Utiliser sql ligne de commande
SQL
0 vote160 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote150 views1 answer
How to select a row in sql
SQL