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

25 votes305 views3 answers
How to use a database to see tables mysql
SQL
0 vote287 views2 answers
How to know the character set of an oracle databes
SQL
0 vote298 views1 answer
Mariadb search columns
SQL
1 vote269 views2 answers
Difference between in and between in sql
SQL
38 votes334 views6 answers
Alter table mysql
SQL
13 votes270 views3 answers
Sql online code
SQL
0 vote310 views1 answer
Postgresql list extensions
SQL
0 vote275 views2 answers
Drop check constraint in ms sql
SQL
0 vote276 views2 answers
Check mysql timezone
SQL
0 vote284 views1 answer
Mysql add root password
SQL