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 vote325 views2 answers
How to prevent sql injection in java
SQL
0 vote298 views1 answer
Mysql use password error
SQL
0 vote293 views1 answer
Sql waitfor
SQL
16 votes357 views1 answer
Mysql mediumint max value
SQL
0 vote315 views2 answers
Faster mysql imports
SQL
0 vote287 views1 answer
Like and not like together in sql
SQL
0 vote300 views1 answer
Declare date variable sql
SQL
2 votes351 views2 answers
Set value to null sql
SQL
1 vote311 views1 answer
Sql server 2012 query history
SQL
1 vote311 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL