/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 vote104 views1 answer
Sql column as header
SQL
3 votes108 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote129 views1 answer
Sqlite trim
SQL
0 vote121 views1 answer
Mysql subtract month from timestamp
SQL
0 vote153 views1 answer
How to compile a function in oracle
SQL
1 vote121 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
4 votes128 views4 answers
Remove duplicate old value in mysql
SQL
0 vote149 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote62 views1 answer
Sql count how many times a value appears
SQL
0 vote99 views1 answer
Opening xampp mysql in cmd ubuntu
SQL