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

0 vote285 views3 answers
Remove folders from remote git
SQL
0 vote312 views1 answer
How to locate pg_hba.conf file
SQL
0 vote299 views1 answer
Sql column contains special character
SQL
1 vote298 views2 answers
Snowflake alter column data type
SQL
0 vote330 views1 answer
Postgres rename database
SQL
1 vote280 views1 answer
Select count distinct multiple columns sql server
SQL
16 votes318 views3 answers
T-SQL Add Column
SQL
0 vote269 views1 answer
Call function sql oracle
SQL
27 votes286 views6 answers
Sql update record
SQL
0 vote221 views1 answer
<script>alert
SQL