Prevent duplicate rows in postgres

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 );

Source: grepper.com

Similar codes

1 vote274 views1 answer
ORA-01950
SQL
2 votes265 views4 answers
List databases in sql server
SQL
5 votes286 views2 answers
Oracle find all tables with column name
SQL
0 vote261 views1 answer
Mysql get last 2 month data
SQL
6 votes283 views2 answers
Mysql execute file
SQL
17 votes267 views3 answers
Postgresql version command
SQL
0 vote240 views1 answer
Sql requete number pair
SQL
0 vote257 views1 answer
What is mysql_pconnect
SQL
1 vote264 views1 answer
Psql connections
SQL
0 vote257 views1 answer
Casterar postgres
SQL