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 vote94 views1 answer
Automate mysql cli query
SQL
0 vote95 views1 answer
Mysql drop multiple tables at once
SQL
8 votes116 views1 answer
Mysql restore database
SQL
3 votes107 views2 answers
Oracle drop column
SQL
1 vote97 views1 answer
Postgres first_value in gropby
SQL
0 vote106 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote130 views1 answer
Mysql return text after a final full stop
SQL
6 votes113 views4 answers
Mysql group by month
SQL
0 vote108 views1 answer
Query only first letter string
SQL
6 votes96 views1 answer
Phpmyadmin reset root password
SQL