/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

2 votes171 views1 answer
Sql like variable
SQL
0 vote186 views1 answer
Limit in access query
SQL
2 votes173 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
1 vote196 views1 answer
How to set up a trigger in sql
SQL
1 vote166 views2 answers
How to enable error squiggles in vs code
SQL
2 votes183 views1 answer
Q operator in plsql
SQL
0 vote193 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote230 views1 answer
ALV GRID events
SQL
1 vote179 views1 answer
Psql search table
SQL
1 vote178 views3 answers
Postgresql connect to database
SQL