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

2 votes286 views1 answer
Sql server: select column values as comma separated string
SQL
1 vote286 views2 answers
Grab part of a string sql
SQL
0 vote259 views1 answer
Check if table exists oracle
SQL
8 votes274 views3 answers
Postgresql connection string c#
SQL
0 vote263 views1 answer
Sql convert datetime to year
SQL
0 vote256 views1 answer
Java input type sql date
SQL
2 votes283 views1 answer
Cast string to datetime mysql
SQL
3 votes271 views1 answer
Force using index plsql
SQL
1 vote299 views5 answers
Postgresql difference between two dates in days
SQL
2 votes297 views1 answer
Q operator in oracle
SQL