/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

3 votes285 views1 answer
Oracle detect invalid password
SQL
-3 votes285 views1 answer
Remove spaces sql 2008
SQL
0 vote309 views1 answer
Como hacer una consulta en sql
SQL
0 vote327 views1 answer
Is not numeric sql
SQL
1 vote294 views1 answer
Sql auto date
SQL
1 vote346 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote319 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote315 views1 answer
Sql last time database was accessed
SQL
2 votes306 views3 answers
Oracle show column of table
SQL
0 vote305 views1 answer
Datagrip go to line
SQL