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 vote318 views1 answer
Mysql 3 months ago
SQL
0 vote287 views1 answer
Sqlite commands
SQL
1 vote302 views1 answer
Oracle previous year
SQL
5 votes286 views1 answer
Oracle generate list of dates in between a date range
SQL
13 votes315 views2 answers
Oracle select into and inner join
SQL
1 vote262 views2 answers
Mysql SELECT
SQL
0 vote323 views1 answer
Get role postgres
SQL
10 votes303 views3 answers
Sql select between two dates
SQL
3 votes305 views1 answer
Unsigned int in mysql
SQL
1 vote290 views1 answer
Postgres set column equal to another
SQL