/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

1 vote141 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote140 views1 answer
We are intrested to work with your organization
SQL
0 vote205 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
0 vote150 views1 answer
Tinydb add table
SQL
1 vote548 views1 answer
How to lock table in mysql
SQL
0 vote141 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
21 votes181 views3 answers
Average sql
SQL
10 votes130 views4 answers
Join with multiple conditions sql
SQL
10 votes106 views2 answers
Mysql select timestamp group by day
SQL
0 vote144 views1 answer
Mysql zerofill
SQL