/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

12 votes269 views4 answers
Mysql version
SQL
1 vote245 views1 answer
Psql show with user is logged in
SQL
1 vote300 views1 answer
How to set up a trigger in sql
SQL
25 votes267 views1 answer
Mysql grant all privileges to a user
SQL
1 vote273 views1 answer
Mysql month name extract
SQL
1 vote316 views1 answer
STOP message of how many rows affected sql
SQL
0 vote261 views1 answer
Joins vs includes
SQL
0 vote258 views4 answers
Sql limit 1 offset 1
SQL
1 vote276 views1 answer
ALL_TAB_PARTITIONS
SQL
7 votes284 views2 answers
Postgres concat
SQL