/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

11 votes210 views6 answers
Mysql else if
SQL
0 vote334 views1 answer
Jpa generationtype sequence mysql
SQL
12 votes204 views4 answers
Mysql version query
SQL
4 votes196 views2 answers
Postgres update single column
SQL
1 vote194 views1 answer
What is int in mysql
SQL
2 votes195 views1 answer
Oracle index size calculation
SQL
0 vote205 views1 answer
Mysql dump everythign
SQL
10 votes203 views1 answer
Query to find object dependencies in oracle
SQL
-1 vote205 views3 answers
MySQL shutdown unexpectedly
SQL
11 votes205 views2 answers
Insert current date sql
SQL