/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 vote152 views1 answer
Oracle index hint
SQL
1 vote166 views1 answer
Query for all indexes in table postgres
SQL
0 vote154 views1 answer
Mysql select where field like in list
SQL
0 vote152 views1 answer
T-sql email validation
SQL
12 votes163 views6 answers
Between in sql
SQL
3 votes158 views2 answers
Mysql config user password
SQL
1 vote172 views1 answer
Tsql replace value in json
SQL
4 votes159 views1 answer
Wilayah indonesia sql
SQL
13 votes157 views1 answer
Views in sql
SQL
3 votes189 views4 answers
Mysql create table from select statement
SQL