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

8 votes154 views2 answers
Replace string value in sql
SQL
10 votes145 views3 answers
Sql limit results
SQL
0 vote155 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote158 views1 answer
Mysql dump everythign
SQL
1 vote140 views3 answers
Java.sql.sqlexception: access denied for user
SQL
2 votes164 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote165 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote154 views3 answers
Remove folders from remote git
SQL
0 vote165 views1 answer
Query params sql insert python f string
SQL
1 vote168 views1 answer
Postgres left join
SQL