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

36 votes259 views6 answers
Change column data type sql
SQL
1 vote142 views1 answer
Altering the column name in MySQL to have a default value
SQL
16 votes138 views3 answers
Delete row psql
SQL
1 vote244 views1 answer
Mysql data from file
SQL
15 votes139 views1 answer
Mysql int range
SQL
0 vote140 views1 answer
Spark sql grows beyond 64 kb
SQL
2 votes162 views3 answers
Sql server: how to concatenate column data using comma
SQL
1 vote138 views1 answer
Postgresql reset serial counter after deleting content
SQL
8 votes137 views1 answer
Sql limit results returned
SQL
3 votes145 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL