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 vote339 views2 answers
Mysql allow remote connections
SQL
0 vote315 views1 answer
Oracle execute immediate quotes
SQL
0 vote310 views1 answer
How to get inserted id in sql server
SQL
0 vote286 views2 answers
Delete the last item in a table sql
SQL
0 vote363 views1 answer
Prisma transaction
SQL
0 vote333 views1 answer
Execut sql python
SQL
0 vote333 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote315 views1 answer
Drop all procedures sql server
SQL
2 votes310 views1 answer
Oracle sql query to make column data uppercase
SQL
1 vote326 views1 answer
Postgresql last element of array
SQL