/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 vote204 views1 answer
Sql server cast date dd/mm/yyyy
SQL
1 vote219 views1 answer
Create new index takes long time postgresql
SQL
0 vote184 views1 answer
Select value from previous row in postgresql
SQL
2 votes208 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote233 views1 answer
Parent and child link in mysql
SQL
0 vote219 views1 answer
Drop-toys-table
SQL
1 vote197 views1 answer
Delete mysql from mac
SQL
0 vote193 views1 answer
Mysql drop multiple tables at once
SQL
7 votes201 views2 answers
Get database size mysql
SQL
1 vote198 views3 answers
Mariadb add foreign key
SQL