/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 vote276 views1 answer
Difference between cross apply and inner join
SQL
6 votes335 views3 answers
Psql show columns of table
SQL
2 votes325 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote320 views1 answer
Mysql date without time
SQL
0 vote320 views1 answer
Psql initialization
SQL
0 vote299 views1 answer
Db format in quotation
SQL
0 vote314 views1 answer
Oracle sql add column auto generated value
SQL
3 votes272 views4 answers
Show sql server database
SQL
0 vote302 views1 answer
Mysql select inside sum
SQL
3 votes295 views2 answers
To_char oracle
SQL