/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 vote93 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote151 views1 answer
Oracle winter time change
SQL
0 vote147 views1 answer
Executescalar in sql server
SQL
0 vote142 views1 answer
Is not numeric sql
SQL
0 vote127 views1 answer
Get week day name sql server
SQL
0 vote86 views1 answer
Print sum of values sql
SQL
1 vote135 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
2 votes123 views1 answer
Drop table purge
SQL
13 votes123 views6 answers
Current date sql
SQL
6 votes157 views1 answer
To count number of rows in SQL table
SQL