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

7 votes174 views2 answers
Sql empty table
SQL
0 vote164 views1 answer
Object Information
SQL
0 vote157 views1 answer
Postgresql newline character
SQL
0 vote160 views1 answer
Stop psql server windows
SQL
7 votes160 views1 answer
Sql management studio display line numbers
SQL
24 votes185 views5 answers
List mysql users
SQL
0 vote177 views1 answer
How to check event scheduler status mysql
SQL
0 vote193 views1 answer
Disable database droping sql
SQL
0 vote158 views1 answer
Postgresql array to rows
SQL
0 vote171 views1 answer
Sql add calculated column
SQL