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 vote204 views2 answers
Timing sql queries
SQL
6 votes206 views5 answers
Alter table oracle
SQL
0 vote207 views1 answer
Exit psql
SQL
2 votes211 views2 answers
Enable foreign key checks postgres
SQL
12 votes226 views2 answers
Select into insert sql server
SQL
11 votes193 views2 answers
Sql between date range
SQL
8 votes191 views3 answers
Mysql alter table add index
SQL
0 vote212 views1 answer
Drop column from local database postgres pgadmin
SQL
2 votes204 views1 answer
Brew start postgres manual
SQL
4 votes194 views1 answer
To date oracle with time
SQL