/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 vote394 views1 answer
Alter constraint in sql
SQL
21 votes354 views3 answers
Average sql
SQL
0 vote377 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote352 views1 answer
Oracle gather table statistics
SQL
1 vote370 views2 answers
Sql server concat string and int
SQL
0 vote351 views3 answers
Mysqli count down
SQL
0 vote341 views1 answer
Check index sql server
SQL
9 votes403 views2 answers
Nosql databases
SQL
0 vote379 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
2 votes317 views1 answer
Oracle sql drop column if exists
SQL