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

6 votes155 views3 answers
Mysql create database utf8
SQL
0 vote154 views1 answer
Reona
SQL
1 vote141 views1 answer
Select count distinct multiple columns sql server
SQL
5 votes140 views2 answers
Oracle to_timestamp
SQL
0 vote205 views1 answer
Linux upload database to mysql
SQL
1 vote167 views1 answer
Import mysql dump database command line linux
SQL
18 votes133 views3 answers
Mysql query add column with default string value
SQL
1 vote142 views1 answer
Oracle first row
SQL
1 vote139 views1 answer
How to delete record sql delphi
SQL
0 vote183 views1 answer
Month mysql
SQL