/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 vote159 views1 answer
Sql beginning of previous month
SQL
0 vote228 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote163 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote184 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
1 vote178 views1 answer
Update from select oracle
SQL
0 vote172 views1 answer
Group by two columns postgres
SQL
-1 vote178 views3 answers
MySQL shutdown unexpectedly
SQL
2 votes212 views1 answer
Oracle insert or update
SQL
0 vote177 views1 answer
Sql include rows with 0 values
SQL
0 vote232 views1 answer
Postgres rename database
SQL