/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

1 vote288 views2 answers
Postgresql remote connect
SQL
4 votes265 views1 answer
Oracle show errors compilation
SQL
0 vote276 views1 answer
Mysql docker image arjun
SQL
0 vote291 views1 answer
Select lowest values sql
SQL
0 vote286 views1 answer
Mysql enter ubuntu
SQL
0 vote269 views1 answer
Turnicate in mysql
SQL
0 vote296 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote285 views1 answer
Mysql timediff
SQL
0 vote320 views1 answer
Oracle winter time change
SQL
0 vote360 views1 answer
How to rename a database in tsql
SQL