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 vote366 views1 answer
Apex for oracle 11g
SQL
0 vote341 views1 answer
Import excel to sql
SQL
0 vote324 views1 answer
Sql roll up rows into columns
SQL
1 vote345 views1 answer
Sqlite create index
SQL
0 vote328 views1 answer
Getting next sequence value jpa postgress
SQL
7 votes307 views1 answer
Alter table add key sql
SQL
2 votes346 views1 answer
Mysql how to store lat,lng
SQL
0 vote384 views1 answer
Sql to search who modified
SQL
2 votes346 views1 answer
Oracle sql day of month from date
SQL
0 vote371 views1 answer
Change role postgres
SQL