/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 vote107 views1 answer
Crontab every month
SQL
5 votes113 views2 answers
Mysql drop table cascade
SQL
4 votes104 views1 answer
Sql any
SQL
0 vote113 views1 answer
Original Query
SQL
0 vote108 views1 answer
Datagrip go to line
SQL
0 vote95 views1 answer
Select value from previous row in postgresql
SQL
1 vote113 views1 answer
Add many column to sap iq table
SQL
0 vote110 views1 answer
Drop-toys-table
SQL
0 vote111 views1 answer
Get clob size oracle
SQL
6 votes117 views1 answer
Identify primary key in oracle table
SQL