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

1 vote318 views2 answers
T sql get foreign key
SQL
1 vote313 views3 answers
Mysql disable foreign keys check
SQL
1 vote342 views1 answer
Round one decimal place mysql
SQL
31 votes321 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote365 views1 answer
Sql cursor example multiple columns
SQL
0 vote332 views1 answer
Renombrar tabla mysql
SQL
10 votes359 views4 answers
Mysql if else
SQL
1 vote315 views1 answer
Mysql batch insert
SQL
8 votes299 views1 answer
Oracle find text in functions
SQL
12 votes326 views4 answers
Mysql ifnull
SQL