/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

1 vote145 views1 answer
Add constraint sql
SQL
2 votes153 views1 answer
Update trigger
SQL
0 vote149 views1 answer
Starting mysql shell lampp ubuntu
SQL
5 votes120 views1 answer
Alter table default value mysql
SQL
0 vote176 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
-1 vote156 views2 answers
First letter capital in mysql query
SQL
0 vote147 views1 answer
SQL SELECT-Klausel
SQL
1 vote162 views1 answer
Sql server: query to find out all the places where the table is used
SQL
3 votes171 views1 answer
Oracle list invalid password logon denied
SQL
0 vote161 views1 answer
C# execute transact sql
SQL