/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 vote216 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote142 views1 answer
T sql return on letters only
SQL
1 vote128 views2 answers
Mysql order by date asc null last
SQL
1 vote278 views1 answer
Postgres convert text to number
SQL
0 vote124 views1 answer
Mysql Install Ubuntu with native password
SQL
7 votes216 views1 answer
Oracle alter sequence restart start with
SQL
0 vote138 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote132 views1 answer
Snap craft
SQL
0 vote142 views1 answer
Sp in sql server
SQL
0 vote131 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL