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 vote189 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote192 views1 answer
How to add mysql to path on termin after installation
SQL
1 vote186 views1 answer
Oracle schema size
SQL
20 votes176 views4 answers
Sqlite create table if not exists
SQL
2 votes166 views3 answers
Mysql cheat sheet
SQL
0 vote188 views1 answer
Sqlite select split string
SQL
2 votes212 views1 answer
Get the mysql table columns data type mysql
SQL
-1 vote164 views1 answer
Sql getdate date only
SQL
19 votes174 views6 answers
What is mySQL
SQL
0 vote186 views1 answer
Sql last 3 rows
SQL