/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 vote180 views1 answer
Multiple count in sql
SQL
7 votes171 views2 answers
Create index mysql
SQL
19 votes194 views6 answers
Sql drop table if exists
SQL
0 vote165 views1 answer
Heavy table in mysql
SQL
0 vote172 views1 answer
What is the essence of SQL?
SQL
0 vote190 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote187 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote196 views1 answer
Can we rollback in sql
SQL
0 vote207 views1 answer
Ms sql print more than 1 variable
SQL
4 votes187 views1 answer
Add constraint fk
SQL