/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 vote402 views1 answer
Create table using the clause with as
SQL
0 vote362 views1 answer
Select row with latest date mysql
SQL
0 vote374 views1 answer
How to find total working hour in sql
SQL
0 vote359 views2 answers
Imageview setimageresource null
SQL
0 vote328 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote401 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote328 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote367 views1 answer
How to insert multiple values in a single column in sql
SQL
2 votes351 views1 answer
Get first 2 letter in sql
SQL
4 votes349 views1 answer
Force drop all tables postgres
SQL