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 vote110 views1 answer
Postgresql get diff between two dates in Months
SQL
0 vote136 views1 answer
Mysql concatenate select results
SQL
0 vote114 views1 answer
Select lowest values sql
SQL
2 votes131 views3 answers
Mysql kill
SQL
1 vote111 views4 answers
Between vs in sql
SQL
0 vote116 views1 answer
Sqlalchemy get ids
SQL
0 vote125 views2 answers
Dbms interview questions
SQL
0 vote110 views1 answer
Mariadb used space
SQL
1 vote113 views2 answers
String to date postgres
SQL
0 vote115 views2 answers
Select index table oracle
SQL