/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 vote213 views1 answer
Oracle search columns in schema
SQL
9 votes226 views1 answer
No sql
SQL
6 votes215 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote221 views1 answer
Except in sql alchemy
SQL
2 votes217 views1 answer
Oracle current date without time
SQL
0 vote237 views1 answer
Compare field sql server
SQL
25 votes234 views3 answers
How to use a database to see tables mysql
SQL
1 vote204 views5 answers
Sql 2nd highest salary
SQL
0 vote181 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
1 vote227 views1 answer
Oracle previous year
SQL