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 vote213 views1 answer
Oracle job schedules
SQL
0 vote217 views1 answer
PSQL qith variables
SQL
0 vote240 views1 answer
Mysql url
SQL
1 vote216 views1 answer
How to drop function in sql
SQL
1 vote214 views1 answer
Oracle update with sequence
SQL
8 votes195 views3 answers
Duplicate entry
SQL
0 vote226 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
6 votes198 views1 answer
Oracle trigger after connect
SQL
1 vote221 views1 answer
Psql datetime grather than
SQL
4 votes211 views1 answer
Select first and last row sql
SQL