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

13 votes210 views3 answers
Uninstall mysql centos 7
SQL
0 vote198 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote209 views7 answers
10 random questions use python and SQL
SQL
9 votes202 views4 answers
Add primary key to existing table sql
SQL
3 votes228 views3 answers
1396(hy00) mysql error
SQL
1 vote189 views1 answer
Use of now() in mysql
SQL
0 vote202 views1 answer
Mysql drop multiple tables at once
SQL
0 vote179 views2 answers
Android sqlite query join
SQL
42 votes276 views6 answers
Sql query duplicate rows
SQL
1 vote199 views2 answers
Sql groub by count
SQL