/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

12 votes191 views4 answers
Mysql version
SQL
0 vote181 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote161 views1 answer
Mysql last 6 months
SQL
0 vote179 views1 answer
Oracle remove line breaks
SQL
0 vote182 views1 answer
Sql server select ignore dupplicates
SQL
0 vote257 views1 answer
Dockerfile example for Django
SQL
0 vote196 views1 answer
Mysql get nth highest
SQL
0 vote169 views1 answer
Mysql use password error
SQL
0 vote170 views1 answer
Find usage of table in sql server
SQL
1 vote160 views3 answers
Grant syntax in sql
SQL