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 vote179 views1 answer
Postgres week number
SQL
0 vote192 views2 answers
Oracle chain rules
SQL
0 vote227 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
3 votes193 views2 answers
Sql select data from last week
SQL
0 vote221 views1 answer
Update sql sintax
SQL
0 vote182 views1 answer
Call rest api from postgresql
SQL
0 vote189 views1 answer
How to to get current date in sql
SQL
0 vote195 views1 answer
Select a row include list of array with join table SQL
SQL
20 votes203 views5 answers
Reset auto increment mysql
SQL
8 votes215 views3 answers
Find table for column name in sql
SQL