/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 vote126 views1 answer
Psql connections
SQL
0 vote118 views1 answer
Mysql group rows with same value
SQL
3 votes80 views4 answers
Show columns from table
SQL
0 vote229 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote119 views1 answer
Parsing float to int in mysql
SQL
0 vote133 views1 answer
Como hacer una consulta en sql
SQL
6 votes122 views1 answer
Phpmyadmin password root
SQL
7 votes155 views1 answer
Oracle pagination query rownum
SQL
0 vote124 views1 answer
Mysql wait_timeout
SQL
0 vote117 views1 answer
Json not contains mysql
SQL