/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 vote223 views2 answers
While mysql
SQL
19 votes244 views1 answer
Sqrt(-1)
SQL
3 votes215 views1 answer
What is having
SQL
2 votes196 views2 answers
Mysql limit
SQL
11 votes233 views2 answers
Sql rank
SQL
0 vote180 views1 answer
The local psql command could not be located
SQL
6 votes238 views2 answers
WHERE value IS sql
SQL
1 vote179 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote177 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote270 views1 answer
Offset in postgresql example
SQL