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

4 votes387 views2 answers
Oracle drop job
SQL
5 votes343 views3 answers
String concatenation sql server
SQL
1 vote349 views1 answer
Decalre temp table sql
SQL
0 vote328 views1 answer
Metada in sql
SQL
0 vote343 views1 answer
Sum sqlserver
SQL
1 vote368 views1 answer
Postgres check blocking
SQL
5 votes382 views4 answers
Upload database mysql command line
SQL
0 vote369 views1 answer
Query string starts with vowels
SQL
16 votes396 views6 answers
Mysql find duplicates in same table
SQL
0 vote380 views1 answer
Postgresql stored procedure update table values
SQL