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

14 votes162 views3 answers
Oracle sql limit results
SQL
0 vote146 views1 answer
Sql count null as 0
SQL
2 votes135 views1 answer
Wait delay in sql server
SQL
1 vote153 views1 answer
Oracle create as select
SQL
0 vote170 views1 answer
Show all sequences postgres
SQL
0 vote149 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
4 votes143 views1 answer
Check database name postgresql
SQL
-3 votes138 views1 answer
Remove spaces sql 2008
SQL
3 votes147 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote155 views1 answer
Mysql update even / odd rows
SQL