/SQL/Postgresql remove duplicate rows 2 columns

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 );

Similar codes

0 vote167 views1 answer
Sqlalchemy case insensitive like
SQL
5 votes177 views2 answers
Mysql dump mysql db cli
SQL
0 vote150 views1 answer
Date on SQL
SQL
-1 vote152 views4 answers
Restart mysql server ubuntu
SQL
0 vote147 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
5 votes142 views3 answers
How to remove unique key constraint in mysql
SQL
46 votes217 views4 answers
Create column sql
SQL
3 votes154 views1 answer
Select sequence oracle
SQL
0 vote141 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote149 views1 answer
Where date major today mysql
SQL