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

24 votes215 views6 answers
Alter table name sql
SQL
1 vote210 views1 answer
How to see all table partition in oracle
SQL
23 votes166 views3 answers
Mysqldump
SQL
0 vote291 views1 answer
Run mysql xampp shell
SQL
-1 vote219 views1 answer
Mysql delete duplicate rows except one
SQL
1 vote244 views2 answers
Limit sqlserver
SQL
0 vote224 views1 answer
Sql basic commands
SQL
0 vote199 views1 answer
Export partttion and import in oracle
SQL
-2 votes207 views2 answers
Union all in sql
SQL
3 votes204 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL