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

-1 vote379 views3 answers
How to restart mysql in linux
SQL
0 vote361 views1 answer
Sql select most frequent value in column
SQL
1 vote384 views1 answer
Table information in sql server
SQL
0 vote358 views1 answer
Vbscript clean up ADODB.Recordset
SQL
14 votes371 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
11 votes384 views3 answers
How to get last row of table in sql
SQL
5 votes366 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
2 votes359 views3 answers
3 days back in sql server
SQL
0 vote390 views1 answer
How to move a columns location in mysql
SQL
57 votes599 views6 answers
Mysql alter table add column
SQL