/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 vote196 views1 answer
Oracle create program if no exists
SQL
27 votes226 views5 answers
Mysql set password for user
SQL
0 vote179 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote190 views1 answer
Timestamp(0) postgresql
SQL
0 vote176 views1 answer
Mysql calculated column
SQL
12 votes187 views4 answers
Mysql version query
SQL
23 votes196 views5 answers
Sql substring
SQL
1 vote193 views1 answer
Retrieve meaning
SQL
1 vote183 views1 answer
Search for replace in mysql
SQL
2 votes185 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL