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 vote335 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote298 views1 answer
T-sql check if data exists
SQL
0 vote330 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote292 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
2 votes309 views1 answer
Date conversion in mysql column
SQL
2 votes316 views1 answer
SELECT INTO
SQL
0 vote293 views1 answer
Mysql delete from where like
SQL
0 vote320 views1 answer
Sql output select
SQL
0 vote287 views1 answer
How many columns can be used for creating index?
SQL
2 votes326 views3 answers
Mysql pass command from command line
SQL