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
Postgresql get last 10 records
SQL
0 vote136 views1 answer
Sql to excel pgadmin
SQL
0 vote107 views1 answer
Datagrip go to line
SQL
0 vote112 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
2 votes121 views1 answer
Mysql id of inserted row
SQL
0 vote126 views1 answer
Pl/pgsql declare variable
SQL
0 vote108 views1 answer
MySQL error code 2068
SQL
10 votes108 views2 answers
Oracle alter sequence nextval
SQL
0 vote104 views1 answer
Wp_query raw sql
SQL
2 votes61 views2 answers
Mysql get last character of string
SQL