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 vote195 views1 answer
Java mysql swing example
SQL
1 vote157 views1 answer
Unique vs distinct sql
SQL
0 vote186 views1 answer
Oracle index hint multiple tables example
SQL
7 votes220 views1 answer
Oracle pagination query rownum
SQL
32 votes201 views6 answers
Sql count where
SQL
4 votes294 views4 answers
Remove duplicate old value in mysql
SQL
0 vote230 views1 answer
Sql create table with references not primary key
SQL
2 votes178 views1 answer
How to delete columns in sql
SQL
1 vote195 views1 answer
Sql server datetime vs datetime2
SQL
51 votes623 views6 answers
Installing mysql on ubuntu
SQL