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 vote60 views1 answer
Sparql list all graphs
SQL
0 vote55 views1 answer
Change magento database url usimg musql
SQL
0 vote54 views1 answer
Find all tables where column name exists oracle
SQL
0 vote54 views1 answer
Ms sql filter all sympbol
SQL
0 vote6 views1 answer
Calculate discount from original price sql
SQL
7 votes50 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
1 vote54 views1 answer
Woocommerce mysql price table
SQL
56 votes106 views5 answers
Psql create user
SQL
6 votes52 views5 answers
Alter table oracle
SQL
0 vote57 views1 answer
Sql get highest date from 3 tabels
SQL