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

3 votes245 views4 answers
Mysql create table from select statement
SQL
0 vote240 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
2 votes256 views1 answer
Mysql virtual column
SQL
1 vote241 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote259 views3 answers
Osx stop mysql service
SQL
0 vote254 views1 answer
Convert rows into columns in oracle
SQL
0 vote213 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
6 votes244 views3 answers
Mysql first day of year
SQL
3 votes249 views1 answer
Oracle rollback
SQL
-1 vote266 views3 answers
SQL MM/dd/yyyy format
SQL