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 vote120 views1 answer
Mysql concat and use as where column
SQL
0 vote134 views1 answer
Oracle get running queries
SQL
0 vote128 views1 answer
Pl/sql loop example
SQL
3 votes187 views6 answers
Jwt laravel
SQL
1 vote105 views1 answer
Oracle compile schema
SQL
2 votes140 views2 answers
Postgresql search all tables for column name
SQL
18 votes135 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote135 views1 answer
Sql #region
SQL
33 votes119 views2 answers
Postgres how to add field created at
SQL
1 vote128 views1 answer
Mysql show data from table
SQL