/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 vote140 views1 answer
Drop CHECK constraint sql
SQL
1 vote135 views1 answer
Mysql query where in select
SQL
0 vote159 views1 answer
Mysql join only one column
SQL
5 votes159 views2 answers
Get columns number sql
SQL
0 vote144 views1 answer
Query params sql insert python f string
SQL
1 vote140 views1 answer
Oracle sql create or replace view
SQL
1 vote145 views2 answers
Mysql between
SQL
0 vote133 views1 answer
Mysql query single row
SQL
0 vote130 views1 answer
Learn sqlite dart
SQL
0 vote137 views2 answers
Sql query inner join 3 tables
SQL