/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

2 votes156 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote149 views2 answers
Zsh: command not found: mysq
SQL
2 votes102 views1 answer
Sql group by different columns
SQL
0 vote191 views1 answer
Mysql could not fetch tables
SQL
1 vote139 views1 answer
Order by oracle
SQL
38 votes228 views6 answers
Ubuntu install mysql client
SQL
0 vote146 views1 answer
Mariadb cast to int
SQL
0 vote144 views1 answer
Mysql change default collation
SQL
13 votes149 views1 answer
Select count of distinct values sql
SQL
0 vote146 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL