/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 vote123 views3 answers
Nth highest salary
SQL
20 votes108 views3 answers
SQL query rename table
SQL
0 vote109 views1 answer
Renommer schema sql
SQL
1 vote126 views1 answer
Sql how to duplicate a table
SQL
2 votes110 views1 answer
Mysql how to store lat,lng
SQL
1 vote140 views1 answer
Show databases mysql docker
SQL
1 vote116 views2 answers
List tables sqlalchemy
SQL
6 votes127 views2 answers
Psql load dump
SQL
0 vote117 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote152 views1 answer
Mysql faster delete
SQL