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

49 votes409 views6 answers
Mysql add column to table
SQL
0 vote344 views2 answers
Update information in a mysql column
SQL
0 vote349 views1 answer
Oracle sql add column auto generated value
SQL
0 vote352 views2 answers
Sql query inner join 3 tables
SQL
7 votes405 views2 answers
3rd height salary sql
SQL
1 vote332 views2 answers
Sql drop multiple columns if exists
SQL
3 votes368 views1 answer
Sql double index
SQL
0 vote345 views1 answer
Where date major today mysql
SQL
0 vote330 views1 answer
Oracle string substitution
SQL
0 vote317 views1 answer
Sql if else in select
SQL