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 vote146 views1 answer
Reset postgresql password windows
SQL
2 votes124 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
1 vote271 views3 answers
Sql subquery
SQL
5 votes148 views1 answer
Purge undo tablespace usage
SQL
1 vote82 views1 answer
Postgresql last element of array
SQL
0 vote136 views1 answer
Oracle array
SQL
0 vote266 views1 answer
The differnece between to values in sql
SQL
5 votes121 views1 answer
Sql first day of current year
SQL
2 votes130 views1 answer
Anonymous block plsql
SQL
4 votes139 views1 answer
Oracle show errors
SQL