/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 vote294 views1 answer
What are the aggregate function in sql
SQL
1 vote301 views1 answer
Sql select where id not exists in another table
SQL
2 votes312 views1 answer
Oracle current date without time
SQL
0 vote341 views1 answer
Mysql 3 months ago
SQL
0 vote308 views1 answer
Sql insert tuple
SQL
28 votes314 views4 answers
Show tables mysql
SQL
0 vote287 views1 answer
Bigquery information_schema schema all columns
SQL
2 votes294 views1 answer
Username sql
SQL
0 vote276 views1 answer
Postgres delete where id in
SQL
0 vote292 views1 answer
Postgresql subquery
SQL