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

-1 vote112 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote131 views1 answer
Sql include rows with 0 values
SQL
0 vote123 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote124 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes124 views1 answer
Sql column values comma separated
SQL
2 votes129 views2 answers
Create temporary table in mysql
SQL
2 votes129 views4 answers
Mysql get all tables row count
SQL
0 vote133 views1 answer
Get id if is not equal in certain table
SQL
0 vote142 views1 answer
Import sql inside hide sql
SQL
0 vote141 views1 answer
Postgresql inline table
SQL