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 votes244 views1 answer
Oracle create datafile
SQL
0 vote243 views1 answer
Sql server roles and users
SQL
0 vote258 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote225 views2 answers
Postgresql create role
SQL
1 vote250 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote231 views1 answer
How to use group_concat in sql server
SQL
10 votes236 views4 answers
Inner join in update query mysql
SQL
0 vote233 views1 answer
Replace sqlalchemy
SQL
13 votes250 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote291 views1 answer
Hierarchal database table
SQL